Posted by Mike Curry on 01/02/06 04:19

I have 2 tables, I will add sample data to them to help me explain...

Table1
(Fields: A, B)
=====
1,One
2,Two
3,Three

Table2
(Fields: A,B)
=====
2,deux
9,neuf

I want to create a query that will only return data so long as the key
(Field A) is on both tables, if not, return nothing. How can I do
this? I am thnking about using a 'JOIN' but not sure how to implement
it...

i.e: 2 would return data- but 9 would not...

any help would be appreciated.

[Back to original message]