Date: 02/22/06 (MySQL Communtiy)    Keywords: no keywords

Hi all,
I have two tables

drugs
drug_id | drug_name

qty_price
pharmacy_id | drug_id

I need a fast efficient select that will return all drug IDs that are not in qty_price. The drug table will have thousands of records and the qty_price table will approx. 4 to 5 times that amount.

Any helpful suggestions including restructuring if needed as appreciated.

Source: http://community.livejournal.com/mysql/86398.html