MySQL 内连接查询

SELECTm.name,c.name,m.age 

FROM man ASm,  cid AS c

WHERE c.id = m.sex; 

-----------------------

SELECT m.name,c.name,m.age 

FROM man AS m

[INNER|CROSS] JOIN cid AS c

ON c.id = m.sex;  

--- 多个 -------------

SELECT ...

FROM ..

JOIN ...

ON...

JOIN ...

ON...