Re: Complex query

2007-08-02 Thread Benjamin Ventura
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

Complex query

2007-08-02 Thread Benjamin Ventura
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