Three tables like this: -------------- product_lines -------------- id title
-------------- manufacturer -------------- id title -------------- manufacturer_product_line_index -------------- id product_line_id manufacturer_id The index provides a one to many relationship - one product line can be associated with more than one company. How do I get a list of product lines not in the index? Thanks, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]