asked on

Join unrelated tables

Hi,

I have two tables that are technically unrelated but I would like them all returned together in one big query.

Obviously if I try and do a normal SQL statement combining the two it results in a cartesian join.

I can't use Union as the return columns differ between the tables.

I am quite happy with NULL's in the columns where that table doesnt have that data.

Is this possible?

Thanks.

James.

ASKER CERTIFIED SOLUTION

ShogunWade

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Partha Mandayam

You can use outer joins.
If you have two tables tbl1 and tbl2,

Left join will return all records from tbl1 and matching from tbl2
Right join will return all records from tbl2 and matching from tbl1.

If you post detailed table structures and desired results I can help you with the exact query.

JAMES

ASKER

How totally cool was that answer - works a treat...

Thanks a bunch.

James.

FDzjuba

join

SELECT table1.col1,table2.col1,table2.col2 FROM table1 INNER JOIN table2 ON table1.id=table2.id

combine everything without any rules
SELECT table1.*,table2.* FROM Table1,Table2

ShogunWade

glad to help :)

JAMES

ASKER

Thanks guys but ShogunWade has the answer....

mcp111 and FD - cant use joins as I stated the two tables were unrelated.

FD - if you use your second example you create a cartesian join which I had already experienced.

Thanks all.

ShogunWade

PS. FD, more modern syntax for SELECT table1.*,table2.* FROM Table1,Table2 is SELECT * FROM Table1 CROSS JOIN Table2