On Wed, 2004-03-31 at 16:08, Chris Boget wrote: > I have 2 tables (looks best in fixed width font): > > test_items > +-------+----------+ > | name | rec_num | > +-------+----------+ > | Book | 1 | > | Game | 2 | > +-------+----------+ > > test_attributes > +---------------+------------+ > | item_rec_num | attribute | > +---------------+------------+ > | 1 | Thick | > | 1 | Tall | > | 1 | Green | > | 2 | Narrow | > | 2 | Yellow | > +---------------+------------+ > > How can I query the above tables so that if I select name and > attribute, the result set comes out looking like this: > > +-------+-------------------+ > | name | attribute | > +-------+-------------------+ > | Book | Thick/Tall/Green | > | Game | Narrow/Yellow | > +-------+-------------------+ > > Because every join query I've been able to think of always > returns the result set as follows: > > +------+-----------+ > | name | attribute | > +------+-----------+ > | Book | Thick | > | Book | Tall | > | Book | Green | > | Game | Narrow | > | Game | Yellow | > +------+-----------+ > > So my question, is it even possible to do what I'd like to do? > > thnx, > Chris
Take a look at qiktable here www.qiktable.com If you are putting that data into a html table qiktable can generate the table on the fly from the data coming back from your query. It is highly configurable, and I believe it will do what you are trying to accomplish. Sean -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
