SELECT product_lines.* FROM product_lines LEFT JOIN
manufacturer_product_line_index ON
manufacturer_product_line_index.product_line_id = product_lines.id WHERE
product_lines.id IS NULL

-----Original Message-----
From: Ed Lazor [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 07, 2005 11:39 AM
To: mysql@lists.mysql.com
Subject: Query question

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]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to