+ 1
mySql: two tables
why this query returns (row of table1* row of table2) number of records. select tab1.name from tab1,table2;
1 Answer
+ 1
select from table1, table2 is similar to
select * from table1
inner join table2 On 1=1
then return for any record of table1 all record of table2