How to SELECT * FROM two unassociated tables?

[Curtis360it]

If I have two tables with zero association, can I do a SELECT query to pull all rows from both tables?

Example:

SELECT *
FROM House,Apartment

 

[SQLDenis]

example in pubs by using a full outer join, what you are doing is a cross join and for every row in one table all rows in the otherv tbale will be selected

use pubs
go

select * from authors a 
full outer join publishers p on a.au_id = p.pub_id

cross join

use pubs
go

select * from authors ,publishers

if the tables have the same number off columns you could do a union


Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions