grouping with more than 1 field
dear all, i just want to know, it is posible to make a group base on the dataset but using multiple field like <q1."isManager"> and <q1."isFieldWorker">, other than using nested group for each condition.
thanks and regards,
ryan
thanks and regards,
ryan
Comments
Something like this within your query:
Select isManager+isFieldWorkder as MasterGroup,isManager,isFieldWorker
From MyTable
Group by MasterGroup
Regards,
Django