>if i select from one of our transaction tables, maybe 30-50 fields do i have to list each of these fields in the group by?
If you use an aggregate function (SUM, COUNT, etc.), yes. But the real question is, Do you realy need all these fields to get the SUM/COUNT/etc. you need? IOW, Are all these fields needed to make a distinct key?
>what if i link tables?
Only the fields specified in the main SELECT need to be included in the GROUP clause.
Ex.: SELECT MyField1, MyField2, COUNT (*) FROM MyTable1 WHERE MyField3 EXIST IN (SELECT MyField3 FROM MyTable2) GROUP BY MyField1, MyField2
HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement