grouping with more than 1 field

maeve_zahra · January 2005

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 · January 2005

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 · January 2005

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

grouping with more than 1 field

Comments

Leave a Comment