Hi all,

I have two v4 tables (one field in each). I want to find the records
that are in one table and not the other. Say

Table A:
Apple
Orange
Pear

Table B:
Apple
Banana
Pear
Grape

The required output would be
Orange
Banana
Grape

The long to do it would be to iterate through Table A and find which
record is not found in Table B, then do the same with Table B. Is
there something like a 2 line SQL that will do this?

Thanks.

Pat

Pat

> I have two v4 tables (one field in each). I want to find the records
> that are in one table and not the other. Say
>
> Table A:
> Apple
> Orange
> Pear
>
> Table B:
> Apple
> Banana
> Pear
> Grape
>
> The required output would be
> Orange
> Banana
> Grape

How about

SELECT fieldname FROM TableA WHERE fieldname NOT IN (SELECT fieldname FROM
TableB)
UNION
SELECT fieldname FROM TableB WHERE fieldname NOT IN (SELECT fieldname FROM
TableA)

John

Hi John,

>> The long to do it would be to iterate through Table A and find which
>> record is not found in Table B, then do the same with Table B. Is
>> there something like a 2 line SQL that will do this?

>How about
>
>SELECT fieldname FROM TableA WHERE fieldname NOT IN (SELECT fieldname FROM
>TableB)
>UNION
>SELECT fieldname FROM TableB WHERE fieldname NOT IN (SELECT fieldname FROM
>TableA)

it works great   

thanks very much

Pat