基本上我想左连接3个表我在下面连接了2个表SELECT*FROMShop_idiLEFTJOINShoppersONi.shopper_id=s.uidWHEREi.shopper_comp>0ANDi.editor_comp=0ORDERBYi.sid我已经成功加入了Shop_idi和Shoppers我想将客户c添加到我认为的组合中-SELECT*FROMShop_idiLEFTJOINShoppers,ClientscONi.shopper_id=s.uidANDi.cid=c.CIDWHEREi.shopper_comp>0ANDi.editor_comp=0ORDERBYi.s