|first |last |hair | |peter |Jackson |brown |
|pet |hair | |dog |grey | |cat | |
|first |last |hair |pet | |peter |Jackson |brown| | | | |grey |dog | | | | |cat |
SELECT first, last, hair, null AS pet FROM Table1 UNION ALL SELECT null, null, hair, pet FROM Table2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)