Table A:
| col1 | col2 | col3 | col4 | col5 | col6 |
ANY | NULL | NULL | YES | YES | YES |
NULL | NULL | YES | NULL | YES | YES |
NULL | ANY | YES | ANY | NULL | YES |
NULL | NULL | ANY | YES | YES | YES |
Table B:
| col1 | col2 | col3 | col4 | col5 | col6 |
ANY | NULL | NULL | YES | ANY | YES |
ANY | NULL | YES | NULL | YES | YES |
NULL | ANY | YES | NULL | NULL | YES |
ANY | NULL | ANY | YES | YES | NULL |
column values are
Yes: Value present
No: Null
Any : Junk
Need to match all the columns from TableA to TableB.
TableA.col1 to TableB.col1
.
.
.
TableA.col6 to TableB.col6
Any help is much appreciated
Thanks,