好不容易写出来了
例子
SELECT p.p_name,s.s_name,os.os_name,o.* FROM myorder o
LEFT JOIN product p ON o.pro_id = p.p_id
LEFT JOIN store s ON o.s_id = s.s_id
LEFT JOIN order_state os ON o.state = os.os_id
左连接是以左表为主
右连接时以右表为主
好不容易写出来了
例子
SELECT p.p_name,s.s_name,os.os_name,o.* FROM myorder o
LEFT JOIN product p ON o.pro_id = p.p_id
LEFT JOIN store s ON o.s_id = s.s_id
LEFT JOIN order_state os ON o.state = os.os_id
左连接是以左表为主
右连接时以右表为主