SELECT SNum, Date, Connect FROM PInformation UNION SELECT SNum, Date, Connect FROM Health_Check UNION SELECT SNum, Date, Connect FROM Image_Check
WHERE (PInformation.SNum=Health_Check.SNum AND PInformation.SNum=Image_Check.SNum COLLATE Chinese_PRC_CI_AS)
执行结果显示无法绑定由多个部分组成的标识符“PInformation.SNum”
无法绑定由多个部分组成的标识符“Health_Check.SNum”
无法绑定由多个部分组成的标识符“Image_Check.SNum”
很急,求高人指点