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
