I have a table that contains customers, and another table that has customers
and items they are authorized for.
I would like to show a datagrid (1) with customers that are authorized for a
select item the user choose, and datagrid (2) that shows which customers are
not in that table for that item. The datagrid2 is the one that I am confused
with. The table can contain many items for many stores. So I had the
query:
SELECT store, itemnum
FROM tblCustomers LEFT OUTER JOIN
tblAuthorized ON tblCustomers.Num = tblAuthorized.store
WHERE (tblAuthorized.store IS NULL) AND (tblAuthorized.itemnum = '120027')
This returns no stores?
If I select the itemnumber in a view that connects to this query, so there
is no tblAuthorized.itemnum = '120027', just querying a view of stores that
have that specific itemnumber.
Any way to send a store number to a view and then connect that view (stores
with certain item) to do an outer join with tblCustomers to get those that
are missing with that item?
Thanks for any help.