SQL join 和 where 等多条件连用
本文转For simplicity, assume all relevant fields are NOT NULL.You can do:SELECT table1.this, table2.that, table2.somethingelseFROM table1, table2WHERE table1.foreignkey = table2.p