Two separate fields need to be grouped in one group

Posted by Sigita on Stack Overflow See other posts from Stack Overflow or by Sigita
Published on 2010-03-24T18:02:44Z Indexed on 2010/03/24 18:13 UTC
Read the original article Hit count: 392

Filed under:

I have two fields: Mother's employer and Father's employer, and I need to group on the employer. Could somebody help me combine the two above fields into one group?

Both fields are in one table. FOr example a child named John Lewis is a record in a table and he has a father and a mother and Mother's employer is IBM and Father's employer is ISF. And so forth. I need to come up with a list By employer where it would show:

Employer: IBM John Lewis

Emplyer: ISF John Lewis

Employer: ....

Thank you,

Sigita

© Stack Overflow or respective owner

Related posts about group-by