sql queries 2 datagrids

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top