0

i have 2 tables but key is not common ..want to join 2 tables...
i want all the coloums in first table and only one coloums in second table..how can i join...i cont use join query without key is common rite ..can anyone tell me plz

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by Upsilon
0

Would something like this SQL query do the job?

SELECT table1.field1, table1.field2, table2.field1
FROM table1, table2;

I am pretty sure it doesn't need a common key as I am doing a Cartesian product.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.