Posted by Jim Moseby on 07/08/05 20:10

Jim F wrote:
> Hi,
>
> I have two tables (A and B) with id fields in them, I would like a list of
> ids that are in A but not in B.
>
> How would I do this in SQL?
>
> Thank you,
>
> Jim
>
>

I have no way to test this where I am right now, but it will be
something like this:

select ID from table_a left join table_B on table_a.ID=table_b.ID where
table_b.ID is null;

JM

[Back to original message]