i want to merge 4 tables together but then i discover they have nothing in common, how do i go about that.
Anybody help me please....
May be concatenate them instead of joining them?
Concatenate is good option as suggested by Sunny
Why Do you want to merge all four table? Are they Fact Tables?
It depends on how you want to join them. Concatenate will get you a full table with all the columns but it will give you the form in the picture I'm attaching with the column names at the very top in the usual place.
Retrieving data ...