How to select multiple counts from multiple tables

How to select multiple counts from multiple tables

El Forum
Guest

09-03-2009, 05:44 AM

[eluser]jedd[/eluser]
When you say 'random results' - have you analysed the numbers in your various Cats results to see what they actually correlate to in your test data?

Are your total*'s disregarding the left joins, for example.

Btw, do you really need product_ in front of all the table names?

Messages In This Thread

How to select multiple counts from multiple tables - by El Forum - 09-02-2009, 03:09 PM

How to select multiple counts from multiple tables - by El Forum - 09-02-2009, 06:13 PM

How to select multiple counts from multiple tables - by El Forum - 09-02-2009, 08:28 PM

How to select multiple counts from multiple tables - by El Forum - 09-03-2009, 05:44 AM

How to select multiple counts from multiple tables - by El Forum - 09-03-2009, 05:58 AM

How to select multiple counts from multiple tables - by El Forum - 09-03-2009, 06:16 AM

How to select multiple counts from multiple tables - by El Forum - 09-03-2009, 06:21 AM

How to select multiple counts from multiple tables - by El Forum - 09-03-2009, 06:27 AM

How to select multiple counts from multiple tables - by El Forum - 09-03-2009, 07:56 AM