LOOKUP HELP!!!!!!

  • Thread starter Thread starter Mr. Damon
  • Start date Start date
M

Mr. Damon

I'm trying to get the query to show me every time Table 1 matches with Table
2. I'm not having any luck though. I need it to show me when if Refernce in
Table Matches Table 2 and to show me the detail of everything
Table 1
Refernece Number
17423
12008444
12008173
12005922
12012230
12004523

Table 2
Refernece Number
17423
12008444
41818
1151819
12012230
12004523
 
SELECT *
FROM Table1
INNER JOIN Table2
ON Table1.[Reference Number] = Table2.[Reference Number]

You might need to change the spelling of Reference to the way you have it
spelled.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
Back
Top