mysql SQL statement help

admin

Administrator
Staff member
I want to select W and X from extra_table, and A, B and C from home_table in the same SQL statement.

How do I do that?

Is it "join"? Is MySQL compatible with that?

Pseudo Code:
SELECT
A.home_table,
B.home_table,
C.home_table,

W.extra_table,
X.extra_table
WHERE ID = 434
 
Back
Top