Access Minus with multiple fields to join on
Posted on 2006-10-24
I have the following query and do not know how to restructure it for Access:
SELECT "Computer" AS sType, DynamicInventory.Manufacturer AS sVendor, DynamicInventory.Model AS sModel, DynamicInventory.[Memory (KBytes)] AS Memory, DynamicInventory.CPU, '10/23/2006' AS dDateAdded, DynamicInventory.Retired
WHERE DynamicInventory.Retired Is Null
Select sType, sVendor, sModel, Memory, CPU, dDateAdded
Where Memory is not null
and CPU is not null;
I can't do a join or a not in because it takes multiple fields to join these two tables. Vendor, Model, Memory and CPU together make it unique. The first table is an imported csv file that is updated regularly, so I can't just add a column to give a unique key and compare on that.
Any ideas are appreciated, thank you!