List unique records and combine from two tables

[S N]

I have two tables with 2 fields identical in both the tables. Other fields
are different in the two tables.
I want to list the unique records from the common field of one table and
also list records from the identical field in the other table (only those
records which are not available in the identical field of first table).

Please advise.

S N

 

[Evertjan.]

S N wrote on 14 mrt 2009 in microsoft.public.inetserver.asp.db:

I have two tables with 2 fields identical in both the tables. Other
fields are different in the two tables.
I want to list the unique records from the common field of one table
and also list records from the identical field in the other table
(only those records which are not available in the identical field of
first table).

[Please do not multipost]

Better read up on SQL joins.

<http://www.w3schools.com/Sql/sql_join.asp>

[INNER] JOIN: Return rows when there is at least one match in both tables