I HAVE A PROBLEM IN HAND,

I have a table A with records as under

Col1 col2 col3
----- ----- -----
A 1 ok
B 1 ok
C 1 ok
D 1 ok

table B

Col1 col2 col3
----- ----- -----
C 0 ok
D 0 ok
E 0 ok
F 0 ok

I want to output to be

Col1 col2 col3
----- ----- -----
A 1 ok
B 1 ok
C 1 ok
D 1 ok
E 0 ok
F 0 ok


Thanks and regards,

Paddy