unique distinct 1

[pacificwaters]

I execute this statement:
select table1.column1, table2.column2 from table1, table2;

and recieve this result:
col1val1 col2val1
col1val2 col2val1
col1val1 col2val2
col1val2 col2val2

what do i change in the above statement, so that i get this result:
col1val1 col2val1
col1val2 col2val2

thanks.

 

[SQLSister]

You have written a cross join because you specified no join fields. You need to write an inner join. Suggest you read up on joins before going any further.

"NOTHING is more important in a database than integrity." ESquared

 

[PHV]

Have a look here:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Ascalonian]

And just so you know, that is referred to as a Cartesian. It means that for ever row in table1, it matches it to a row in table 2. That is why you are getting so many results.