Member Avatar for sivak

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
  • 76 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Upsilon
Member Avatar for Upsilon

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.