这段SQL语句的功能from t_rpContractEntry t1left join t_ICItem t2 on t2.fitemid=t1.fproductid left join t_RPContract t3 on t1.FContractID=t3.FContractIDleft join t_Organization t4 on t3.FCustomer = t4.fitemid数据库降级了下,有几个SQL公
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/24 06:14:13
![这段SQL语句的功能from t_rpContractEntry t1left join t_ICItem t2 on t2.fitemid=t1.fproductid left join t_RPContract t3 on t1.FContractID=t3.FContractIDleft join t_Organization t4 on t3.FCustomer = t4.fitemid数据库降级了下,有几个SQL公](/uploads/image/z/13141504-64-4.jpg?t=%E8%BF%99%E6%AE%B5SQL%E8%AF%AD%E5%8F%A5%E7%9A%84%E5%8A%9F%E8%83%BDfrom+t_rpContractEntry+t1left+join+t_ICItem+t2+on+t2.fitemid%3Dt1.fproductid+left+join+t_RPContract+t3+on+t1.FContractID%3Dt3.FContractIDleft+join+t_Organization+t4+on+t3.FCustomer+%3D+t4.fitemid%E6%95%B0%E6%8D%AE%E5%BA%93%E9%99%8D%E7%BA%A7%E4%BA%86%E4%B8%8B%2C%E6%9C%89%E5%87%A0%E4%B8%AASQL%E5%85%AC)
这段SQL语句的功能from t_rpContractEntry t1left join t_ICItem t2 on t2.fitemid=t1.fproductid left join t_RPContract t3 on t1.FContractID=t3.FContractIDleft join t_Organization t4 on t3.FCustomer = t4.fitemid数据库降级了下,有几个SQL公
这段SQL语句的功能
from t_rpContractEntry t1
left join t_ICItem t2 on t2.fitemid=t1.fproductid
left join t_RPContract t3 on t1.FContractID=t3.FContractID
left join t_Organization t4 on t3.FCustomer = t4.fitemid
数据库降级了下,
有几个SQL公式不能计算了,应该是是以上SQL语句问题
作用我大致看了下,应该是建立T1~T4几个表格
我查过字段里面 t_rpContractEntry 几个表格都是存在的就是没字节,
但是不能运行,能不能帮看下哪里出错了
消息 156,级别 15,状态 1,第 1 行
关键字 'from' 附近有语法错误.
这段SQL语句的功能from t_rpContractEntry t1left join t_ICItem t2 on t2.fitemid=t1.fproductid left join t_RPContract t3 on t1.FContractID=t3.FContractIDleft join t_Organization t4 on t3.FCustomer = t4.fitemid数据库降级了下,有几个SQL公
能把完整的语句发出来吗,以上语句没看见有公式函数,应该没什么问题