Windows 10 
Access 2013 32bit
I am trying to answer the following question:
How many locations have no SKU assigned in the front section of the secondary storage area?
There are the queries I came up with now:
SELECT L4.Locationavailable_pk
FROM Layout04_DA_LocationsAvailable AS L4
WHERE LEFT(L4.Locationavailable_pk,2) = 'SF'
=4698 records
SELECT SS.SkuID_fk, SS.SecLocation_fk
FROM IM_DA_SecStorageAssignments AS SS
WHERE LEFT(SS.SecLocation_fk,2) ='SF'
=4579 records
The difference 119 records. I need to combine these two queries into one query that outputs my 119 records.
Reply With Quote
