sql queries 2 datagrids

[AshleyT]

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.

[W.G. Ryan eMVP]

Don't use a Join for this unless you are 100% positive you don't want to use
a DataAdapter for your updates - and even then I'd avoid it. Use a
DataRelation and two separate queries, two separate adapters - life will be
SOOO much better for you .
http://www.knowdotnet.com/articles/datarelation.html
"AshleyT" <As*****@discussions.microsoft.com> wrote in message
news:E3**********************************@microsof t.com...

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.