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

Comments

  • edited 6:12PM
    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
  • edited 6:12PM
    thanks for the solution, that's what i do now. it working perfect. ;)

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.