mysql的左连接多个条件_使用If条件选择多个字段,在mysql中使用左连接 – 抛出错误...

任何帮助表示赞赏 –

1064 – 您的SQL语法出错;查看与您的MySQL服务器版本对应的手册,以获得正确的语法,在’as receiverimage附近使用,re.fName作为receiverfName,re.lName作为receiverlName,re.add’在行

SELECT co.*,

if(( co.senderid = 1) , ( re.image as receiverimage, re.fName as receiverfName , re.lName as receiverlName , re.address as receiverAddress , re.city as receivercity , re.state as receiverstate, re.country as receivercountry, re.zipCode as receiverzip),(se.address as senderAddress,se.city as sendercity , se.state as senderstate , se.country as sendercountry , se.zipCode as senderzip , se.image as senderimage ,se.fName as senderfName, se.lName as senderlName ))

FROM contacts as co

LEFT JOIN users as se ON( se.id = co.senderid )

LEFT JOIN users as re ON( re.id = co.receiverid )

where (senderid = 1 OR receiverid = 1)

– 选择连接表上的多个字段是无效还是其他？

我无法弄清楚确切的原因,基本概率.这里是根据基于连接的用户表中的条件选择几个字段.