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

 

[Bob Barrows]

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.

Only if you promise not to multipost in the future
Already answered in .inetserver.asp.db, which was the perfect place for the
question.

 

[S N]

Thanks for the help.
Shall not multipost.

Only if you promise not to multipost in the future
Already answered in .inetserver.asp.db, which was the perfect place for
the question.

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"