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 |
|
amy
Starting Member
30 Posts |
 Posted - 2002-07-02 : 10:10:35
|
| I have 2 tables: tb1 and tb2, there are not related, however I want to joint them to return all the records from both tables: tb1 have 2 records, tb2 hae 1 records SELECT * FROM tb1 CROSS JOIN tb2 but it just return only 2 records from tb1, so how can I have total 3 recors here? Thanks |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-02 : 10:16:11
|
| Having problems understanding what your asking, but I think what you want to use is unionselect * from table1union allselect * from table2Might have to specify what columns you are selecting rather than just *-----------------------Take my advice, I dare ya |
 |
|
|
dsdeming
479 Posts |
Posted - 2002-07-02 : 13:11:04
|
| What do the table structures look like? |
|
|
|
|
|
|
join table