Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-06 : 00:26:14
|
Stefano writes "Hi there, I want to merge 2 tables without any condition on the join clause. Scenario: - First table has a single coloumn (col_1_1)- Second table has a single coloumn (col_2_1)(different number of records)I want to obtain a result table with 2 coloumns: the first one has to be col_1_1 and col_2_1. I don't need any criteria on this merging, it should be like an overlapping of the 2 initial tables.Example:table1: ------- COL_1_1 ------- me you he she we ---table2:--------COL_2_1 --------123 456 789 -----Result table:----------------COL_1_1 ¦COL_2_1 ---------------- me ¦123 you ¦456 he ¦789 she ¦<null> we ¦<null> ----------- I've tried using different JOIN, but...nothing!I'd be very thankful if you could help me.Many thanksStefano" |
|
|
|
|
|
Merging tables