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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
