grouping with more than 1 field

maeve_zahra

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

djangman

One suggestion would be to join or concatenate your two fields into one and group on that calculated field.

Something like this within your query:

Select isManager+isFieldWorkder as MasterGroup,isManager,isFieldWorker
From MyTable
Group by MasterGroup

Regards,

Django

maeve_zahra

thanks for the solution, that's what i do now. it working perfect.