[thelist] SQL - Return tuple only if ALL attributes same thing

Tim Burgan email at timburgan.com
Wed May 18 10:55:26 CDT 2005


Hello,

In my DB I have 2 tables, 'Deliveries' and 'Trucks'.
Deliveries contains a foreign key RegNumber for a truck that makes a 
Delivery.
Trucks has the RegNumber as primary key, and another column called Model.

In the select statement, how do I return results where every single 
delivery to a certain customer (customerID in Deliveries table) has been 
made by the same model truck?

I thought the operator 'ALL' may work, but didn't.
Does anyone have any suggestions?

Thanks
Tim



More information about the thelist mailing list