Question

php mysql三个表的内连接语句怎么写

这哪里错了$sql=mysql_query("SELECT s.shoptitle,s.pic , s.mid ,s.sid,ff.GuangGaoFuFei ,ff.ffid,ff.mid,m.mid,m.shopname,m.user from( money AS ff INNER JOIN tb_storeinfos AS s ON ff.sid=s.sid)INNER JOIN tb_members AS m ON s.mid=m.mid where ff.GuangGaoFuFei='1' AND m.shopname!='' ORDER BY ff.GuangGaoKaiShi DESC,m.mid limit 0,12",$conn);

Answer 1

SELECT s.shoptitle,s.pic , s.mid ,s.sid,ff.GuangGaoFuFei ,ff.ffid,ff.mid,m.mid,m.shopname,m.user from money AS ff INNER JOIN tb_storeinfos AS s ON ff.sid=s.sid INNER JOIN tb_members AS m ON s.mid=m.mid where ff.GuangGaoFuFei='1' AND m.shopname!=''
ORDER BY ff.GuangGaoKaiShi DESC,m.mid limit 0,12