Good day,

I have two tables with the same structure

table A & B
-------------
id (int)
parent_id (int)
active (1 in table A / 0 in table B)

I want to union the two tables but i want the end result to override certain values so if table A and table B have the same id the entry from table B won't be in the final table. Maybe its not a union at all, thats why i'm asking for help :-)

example
Table A Table B
---------- -------------
1 null 1 54 45 0
2 1 1 60 65 0
3 2 1 10 3 0
10 3 1


the result would be

Table (A u B)
---------------
1 null 1
2 1 1
3 2 1
10 3 1
54 45 0
60 65 0

Scott