Member Avatar for katiiiii

dear all,
i have 2 tables with no common column. and i wanna add the columns of the second table to the first. but when i use the below command a cartesian product happens!

select column1,column2,column3,column4 from table1,table2

but i want the number of rows be fixed. so i thought of using an index to join 2 tables.

the problem is....
i wanna add the columns randomly, but by using a common field they join in a fixed form... so how can i add the coloumns in the second table to the first, without a repeatation happening and having the randomize charachteristic?


thanks in advance

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by varmadba
Member Avatar for varmadba

I guess you cant do that

DB should know how to join 2 tables or else it will join with all rows in both the tables

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.