mySql: two tables | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
+ 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 Antwort
+ 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