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

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.