mySql: two tables | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

mySql: two tables

why this query returns (row of table1* row of table2) number of records. select tab1.name from tab1,table2;

21st Nov 2022, 6:55 AM
Sunil Shrestha
Sunil Shrestha - avatar
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
21st Nov 2022, 7:10 AM
KrOW
KrOW - avatar