SQL写物料需求

Select a.PRD_NO As [货品代号], b.Name As [货品名称], a.STA_DD AS [开始日期],a.end_dd as [结束日期],a.QTY_GR as [毛需求],
a.QTY_RCV as [计划收到],a.QTY_OUT as [计划发出],a.QTY_WH as [可分配库存],
a.QTY_NON as [净需求],a.QTY_FPO as [已下达计划量],
a.QTY_PLAN as [计划量],a.SO_NO as [计划订单号],
a.NEED_DD as [计划完工日],a.TW_ID as [托外否],
a.QTY_MWH as [预计库存],a.QTY_PORC as [计划定单收],
a.NEED_DAYS as [前置天数]
    

from TF_MRA a,MF_MRA  c,PRDT b  where 

(a.PRD_NO=b.PRD_NO)

 and (c.PRD_NO=a.PRD_No)

 And  c.PLAN_DD>=:DATE_B!开始日期

 And c.PLAN_DD<=:DATE_B!截止日期

 And a.PRD_NO>=:PRDT_B!起止货品

 And a.PRD_NO<=:PRDT_B!截止货品

 And year(c.PLAN_DD)=Year(GetDate())