>Hi. SQL is really giving me a difficult time. Currently, I am trying to
>"Select all of A" + "only the items in B that are not already in A".
>
>Can anyone help?
>
>Thanks, Randy
Assuming the structures of tables A and B are the same, or at least the fields selected from A and B are the same datatypes:
select * from A
union
select * from b where id not in (select id from a)
Mark McCasland
Midlothian, TX USA