Vista - List unique records and combine from two tables

03-14-2009

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

03-14-2009

S N wrote:

Quote:

> 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. :-)

--
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"

03-14-2009

Thanks for the help.
Shall not multipost.

"Bob Barrows" <reb01501@xxxxxx> wrote in message
news:%23Srhg6KpJHA.3572@xxxxxx

Quote:

>S N wrote:

Quote:

>> 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. :-)
>
> --
> 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"
>

03-14-2009	#1 (permalink)
S N n/a posts	List unique records and combine from two tables 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
My System Specs

03-14-2009	#2 (permalink)
Bob Barrows n/a posts	Re: List unique records and combine from two tables S N wrote: Quote: > 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. :-) -- 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"
My System Specs

03-14-2009	#3 (permalink)
S N n/a posts	Re: List unique records and combine from two tables Thanks for the help. Shall not multipost. "Bob Barrows" <reb01501@xxxxxx> wrote in message news:%23Srhg6KpJHA.3572@xxxxxx Quote: >S N wrote: Quote: >> 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. :-) > > -- > 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" >
My System Specs

Similar Threads
Thread	Forum
No MX or A records for ....	Vista mail
First 400 Records in SQL Statement	VB Script
How to write records to SQL Server 2005 tables	PowerShell
tables in wlm	Live Mail
Get-unique	PowerShell