question on select

[Adi Peyyala]

Does a query like this execute:

select * from tablename1, tablename2

tablename1 and tablename2 are two different tables with different schemas.

Adi

[Shailesh Chandra]

Originally posted by Adi Peyyala:
Does a query like this execute:

select * from tablename1, tablename2

tablename1 and tablename2 are two different tables with different schemas.

Adi

Why didn'y you try this ?

answer is yes !!

If your tablename1 has 10 rows and tablename2 has 5 rows then you will get 50 rows in result with all columns of both table.

Shailesh

[Srinivasa Raghavan]

More specifically it's a cross product of two tables.

[Adeel Ansari]

Originally posted by Srinivasa Raghavan:
More specifically it's a cross product of two tables.

And technically its Cartesian Product. You need join between tables.

[s choukse]

Use This to select all columns from both tables.
You will have to join the tables on proper columns to avoid cartesian product.

select tablename1.*, tablename2.* from tablename1, tablename2
where tablename1.col1 tablename2.col1;

Let me know.

s choukse

[Kareem Qureshi]

select * from tablename1, tablename2
tablename1 and tablename2 are two different tables with different schemas.


if you mean they belong to two different databases then
You cannot do a select on two different schemas.

Hope this clarifies

Thanks
Kareem