query joins

[danabides]

Hi all,

Simple problem, but my access and sql skills are very limited.

I have two tables. One containing a group of frequent customers with a column called 'member status'. Another table containing a group of non-customers. The addresses in both tables have been matched using group1 software.

I would like to create a query that shows me all the customers with 'member status' = 'A' and all the non-customers who live at the same address.

When i run the query, everybody comes up as 'member status'=A. I think this is because there is no 'member status' field in the non-customers table, and i have failed to make the appropriate join or parameters. Is there a way to design a query that will show 'member status' for those who have it, and will display a null for those who do not?

Any help is appreciated thank you!

 

[danabides]

thanks pat,

but i must be missing something key here.

i queryed for the criteria i wanted, in this case 'member status'=A. and then i joined that query to a larger table, which does not contain the column 'member status'. so, when i run the query all records retrieved are deemed 'member status'=A.

what am i missing here?

 

[danabides]

after toying around with your first post, i finally figured it out. thanks, pat!