|
|
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.
Navigation:
[Reply to this message]
|