I have two non-identical tables. They are pretty similar except a few fields. I want to select everything from both for example
table1 id name age table2 id name height I want id name height age even if it returns null values. select * from table1, table2 seems to give repeat rows for some reason. Thanks, R.