Syntax

[Moose222]

I need to write a query that utilizes two tables, Table A and Table B. The column's that I need to query are Table A, SN and Table B SN2.

I need to check table A, Column SN against, Table B, SN2 Column for the same information. Both column's might have Serial Numbers that have 13 digits, of both numbers and alphanumericas. Such as:

ABH1238743A11

Is there an easy way to write a query for this and show the Serial Numbers that are in both column's in a report?

As usual any help would be appreciated.

Thanks,
Jim

 

[tomschafer]

If I'm understanding you correctly you simply want a query to return information where Table_A.SN=Table_B.SN2? If so you can use this...

SELECT Table_A .SN
FROM Table_A INNER JOIN SN ON Table_B.SN2 = Table_A.SN;