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.

 All Forums
 Other Forums
 Other Topics
 joining tables not having common fields

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-23 : 08:19:57
dpa writes "How do i retrive records from two tables including the once which do not have commonfields"

nr
SQLTeam MVY

12543 Posts

Posted - 2003-12-23 : 08:38:42
select * from tbl1
select * from tbl2

Then deal with the two resultsets?

Maybe a bit more info about what you are trying to do?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -