Re: SUM problem.
I've read more and actually found a nice tutorial about join/left join/right join that made me understand how join works a bit better.
However, all the info I've found on join only join 2 different tables, is it possible to join 3 tables in a single query ?
I've found examples of SELECTs inside SELECTs, is that possible the way I should be heading ?
Kind of like (yes, this is not a correct query but just to put up an example).
SELECT whatever, count (*) AS more,
(SELECT whatever JOIN whatever2),
(SELECT whatever2 JOIN whatever3)
I know that might not be a good example, but is it possible to join 3 tables in that way ? Or is there any other way you join 3 tables together ?
I know I have to read more and hopefully find more tutorials, but a point in the right direction (maybe a few links) would be greatly appriciated :)