son_id
and B.product_type = "Product B"
;
Give it a try !!!
- Original Message -----
From: "Benjamin Ventura" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Thursday, August 2, 2007 1:22:00 PM (GMT-0500) America/New_York
Subject: Complex query
I have a databas
I have a database tracking registrations of software products with two related tables, "registered_products" and "people". I need to pull a list of email addresses from the people table BUT I only want to pull people records who own very specific combinations of products from the registered_produc