Hi guys,
Wonder if anyone can help me out here with a bit of SQL.
I have two tables
Table A which contains partial records
Table B which contains complete records
I have performed a Union on the two tables to produce a master dataset but it this has highlighted a problem to me with duplicates...
Records may exist in Table A and NOT in Table B
Records may exist in Table A and Table B
Records may exist in Table B and NOT in Table A
I need to get all records from table B PLUS those that exist in Table A only.
Anyone able to help me out?
I can post a sample dataset and my current queries if it helps.
Cheers,
G
Wonder if anyone can help me out here with a bit of SQL.
I have two tables
Table A which contains partial records
Table B which contains complete records
I have performed a Union on the two tables to produce a master dataset but it this has highlighted a problem to me with duplicates...
Records may exist in Table A and NOT in Table B
Records may exist in Table A and Table B
Records may exist in Table B and NOT in Table A
I need to get all records from table B PLUS those that exist in Table A only.
Anyone able to help me out?
I can post a sample dataset and my current queries if it helps.
Cheers,
G