INNER JOIN ON vs WHERE子句
为简单起见,假设所有相关字段都是NOT NULL
。
你可以做:
SELECT table1.this, table2.that, table2.somethingelseFROM table1, table2WHERE table1.foreignkey = table2.primarykey AND (some other conditions)
要不然:
SELECT table1.this, table2.that, table2.somethingelseFROM table1 INNER JOIN table2 ON table1.foreignkey = table2.primarykeyWHERE (some other conditions)
这两个是以同样的方式工作MySQL
吗?
哔哔one
慕的地6264312
相关分类