SELECT

e0.FNumber as 项目编号,e0.FName as 项目名称 ,e0.F_QYPD_Date as 业务日期 ,e1.FAmount as 期初材料金额, e2.F_QYPD_Decimal3 as 期初费用金额, (e1.FAmount+e2.F_QYPD_Decimal3 )as 期初汇总,e3.F_QYPD_Text1 as 期初工时,

e4.FAmount as 本期材料金额,e5.F_QYPD_Decimal3 as 本期费用金额,(e4.FAmount+e5.F_QYPD_Decimal3) as 金额汇总,e6.F_QYPD_Text1 as 工时, e7.F_QYPD_Decimal7 as 本期材料金额,e8.F_QYPD_Decimal1 as 本期费用金额,

(e7.F_QYPD_Decimal7+ e8.F_QYPD_Decimal1) as 金额汇总 ,e9.FBillStatus3 as 工时 ,e10.F_QYPD_Decimal10 as 期末材料金额,e11.F_QYPD_Decimal1 as 期末费用金额,(e10.F_QYPD_Decimal10+e11.F_QYPD_Decimal1) as 金额汇总,

e12.F_QYPD_Text1 as 工时,

e12.FBILLSTATUS3 as 是否完工

FROM (

SELECT t0.F_QYPD_ORGID1 AS F_QYPD_OrgId1,t0.F_QYPD_DATE AS F_QYPD_Date,t0.FNUMBER AS FNumber,t0_L.FNAME AS FName FROM QYPD_t_Cust100008 t0 LEFT JOIN

QYPD_t_Cust100008_L t0_L ON (t0.FID=t0_L.FID AND t0_L.FLocaleId=2052)

) e0

CROSS JOIN (

SELECT t1.FAMOUNT AS FAmount FROM T_STK_MISDELIVERY t0 LEFT JOIN T_STK_MISDELIVERYENTRY t1

ON (t0.FID = t1.FID ) WHERE

t0.FOBJECTTYPEID = 'STK_MisDelivery' and FDATE >= DATEADD(MONTH,DATEDIFF(month,0,getdate())-1,0) and FDATE < DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)

) e1

CROSS JOIN (

SELECT t1.F_QYPD_DECIMAL6 AS F_QYPD_Decimal3 FROM QYPD_t_Cust_Entry100020 t1 where F_QYPD_DATE2 >= DATEADD(MONTH,DATEDIFF(month,0,getdate())-1,0) and F_QYPD_DATE2 < DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)

) e2

CROSS JOIN (

SELECT t0.F_QYPD_TEXT14 AS F_QYPD_Text1 FROM QYPD_t_Cust100014 t0

) e3

CROSS JOIN (

SELECT t1.FAMOUNT AS FAmount FROM T_STK_MISDELIVERY t0 LEFT JOIN T_STK_MISDELIVERYENTRY t1

ON (t0.FID = t1.FID ) WHERE

t0.FOBJECTTYPEID = 'STK_MisDelivery' and YEAR(FDATE) = YEAR(GETDATE()) AND MONTH(FDATE) = MONTH(GETDATE())

) e4

CROSS JOIN (

SELECT t1.F_QYPD_DECIMAL6 AS F_QYPD_Decimal3 FROM QYPD_t_Cust_Entry100020 t1 where YEAR(F_QYPD_DATE2) = YEAR(GETDATE()) AND MONTH(F_QYPD_DATE2) = MONTH(GETDATE())

) e5

CROSS JOIN (

SELECT t0.F_QYPD_TEXT14 AS F_QYPD_Text1 FROM QYPD_t_Cust100014 t0

) e6

CROSS JOIN (

SELECT t0.F_QYPD_DECIMAL9 AS F_QYPD_Decimal7 FROM QYPD_t_Cust100021 t0 where YEAR(F_QYPD_DATE) = YEAR(GETDATE()) AND MONTH(F_QYPD_DATE) = MONTH(GETDATE())

) e7

CROSS JOIN (

SELECT t1.F_QYPD_DECIMAL1 AS F_QYPD_Decimal1 FROM QYPD_t_Cust_Entry100025 t1

) e8

CROSS JOIN (

SELECT t0.FBILLSTATUS3 AS FBillStatus3 FROM QYPD_t_Cust100014 t0

) e9

CROSS JOIN (

SELECT t0.F_QYPD_DECIMAL12 AS F_QYPD_Decimal10 FROM QYPD_t_Cust100021 t0

) e10

CROSS JOIN (

SELECT t1.F_QYPD_DECIMAL1 AS F_QYPD_Decimal1 FROM QYPD_t_Cust_Entry100025 t1

) e11

CROSS JOIN (

SELECT t0.F_QYPD_TEXT14 AS F_QYPD_Text1,FBILLSTATUS3 FROM QYPD_t_Cust100014 t0

) e12

产品问题请问一下我这个sql哪里有问题吗，无法查到数据

20 产品问题 请问一下我这个sql哪里有问题吗，无法查到数据

恭喜您！

产品问题
请问一下我这个sql哪里有问题吗，无法查到数据

20 产品问题请问一下我这个sql哪里有问题吗，无法查到数据