[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