On 29 May 2003 at 11:38, James wrote: > What we envision is a query to return something similar to this: > > +-------------+------------------+--------------------+ > | Item Number | Item Description | Option Description | > +-------------+------------------+--------------------+ > | 1 | car1 | engine, seat, wheel| > | 2 | car2 | seat, doors | > | 3 | car3 | steering wheel | > +-------------+------------------+--------------------+
You could do something like that with the GROUP_CONCAT() function, but unfortunately that exists only in MySQL 4.1. http://www.mysql.com/doc/en/Group_by_functions.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]