SQL Join tables help

tdaustin · January 11th, 2006, 12:07 AM

Hi All,

Im trying to write a SQL statement that will join 2 tables based on a customer has 2 specific products.
eg.

Table 1: Customer

MemberID
MemberName
Email ect

Table 2: Products

ProductID
MID (MemberID of table 1)
ProductName

So how do i write a sql statement to only bring up say cutomers that have a ProductName of "Computers" AND "Laptops" They must have both Computers as an entry in the products table and an entry of Laptops in the relational database.

Your help would be much appreciated.

Tim :)

TDA

ChrisScott · January 11th, 2006, 05:34 AM

Hi Tim,

One way would be to use subqueries...

Code:

SELECT MemberID, MemberName FROM Customer
WHERE MemberID IN(SELECT MID FROM Products WHERE ProductName = 'Computers')
AND MemberID IN(SELECT MID FROM Products WHERE ProductName = 'Laptops');

HTH,

Chris

tdaustin · January 11th, 2006, 04:57 PM

Fantastic!

Thanks chris. exactly what i needed.

Thank you

Tim :)

TDA