MySQL Forums
Forum List  »  Newbie

combining multiple rows
Posted by: William Gilligan
Date: November 11, 2009 04:18PM

Hopefully this is the correct place to post...
I have the following database:
id atid code
312 614 small
312 614 medium
312 614 large
312 614 XL
312 615 black
312 615 blue

I need to list the following info...
- small black
- small blue
- medium black
- medium blue
- large black
- large blue, etc etc...

Any suggestions?

Options: ReplyQuote

Written By
combining multiple rows
November 11, 2009 04:18PM
November 11, 2009 04:23PM
November 11, 2009 04:32PM
November 12, 2009 10:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.