Составной идентификатор не может быть привязан в хранимой процедуре SQL server в запросе select

---

составной идентификатор не может быть привязан в хранимой процедуре SQL server в запросе select

Что я уже пробовал:

SELECT DISTINCT 
                      dbo.master_order.program_no, dbo.transaction_order.pro_no, dbo.Setup_buyer.buyer_code, dbo.Setup_article_production.article_code, 
                      SUBSTRING(dbo.master_lotsmaking.lotno, 4, LEN(dbo.master_lotsmaking.lotno)) AS lotno, dbo.Setup_color.color_no, dbo.Setup_quality_knitting.quality_name, 
                      dbo.transaction_knittingdaily.rollweight AS total_weight, dbo.transaction_knittingdaily.rollno AS rolls, dbo.Setup_yarn.yarn_count, dbo.Setup_machine.guage, 
                      dbo.Setup_machine.gsm, dbo.Setup_machine.machine_no, dbo.Setup_supplier_knitting.supplier_name, Setup_article_production1.article_code AS article_code1, 
                      Setup_article_production2.article_code AS article_code2, Setup_article_production3.article_code AS article_code3, 
                      Setup_article_production4.article_code AS article_code4, Setup_article_production5.article_code AS article_code5, dbo.master_lotsmaking.date2, 
                      dbo.master_lotsmaking.Remarks, dbo.transaction_lotsmaking.took_weight AS tookwt, dbo.master_goods.f_weight, dbo.master_goods.date2 AS Expr1
                      FROM         dbo.master_lotsmaking INNER JOIN
                      dbo.Setup_article_production ON dbo.master_lotsmaking.article_id = dbo.Setup_article_production.article_id INNER JOIN
                      dbo.Setup_color ON dbo.master_lotsmaking.color_id = dbo.Setup_color.color_id INNER JOIN
                      dbo.transaction_lotsmaking ON dbo.master_lotsmaking.mas_id = dbo.transaction_lotsmaking.mas_id INNER JOIN
                      dbo.transaction_knittingdaily ON dbo.transaction_lotsmaking.tr_id = dbo.transaction_knittingdaily.tr_id INNER JOIN
                      dbo.master_knittingdaily ON dbo.transaction_knittingdaily.m_id = dbo.master_knittingdaily.m_id INNER JOIN
                      dbo.Setup_machine ON dbo.master_knittingdaily.machine_id = dbo.Setup_machine.machine_id INNER JOIN
                      dbo.Setup_yarn ON dbo.master_knittingdaily.yarn_id = dbo.Setup_yarn.yarn_id INNER JOIN
                      dbo.Setup_quality_knitting ON dbo.master_knittingdaily.quality_id = dbo.Setup_quality_knitting.quality_id INNER JOIN
                      dbo.master_order ON dbo.master_lotsmaking.order_id = dbo.master_order.order_id INNER JOIN
                      dbo.transaction_order ON dbo.master_order.order_id = dbo.transaction_order.order_id LEFT OUTER JOIN
                      dbo.Setup_buyer ON dbo.master_order.buyer_id = dbo.Setup_buyer.buyer_id INNER JOIN
                      dbo.Setup_supplier_knitting ON dbo.Setup_yarn.supplier_id = dbo.Setup_supplier_knitting.supplier_id INNER JOIN
                      dbo.transaction_goods ON dbo.transaction_lotsmaking.ltr_id = dbo.transaction_goods.ltr_id INNER JOIN
                      dbo.master_goods ON dbo.transaction_goods.m_id = dbo.master_goods.id LEFT OUTER JOIN
                      dbo.Setup_article_production AS Setup_article_production1 ON dbo.master_lotsmaking.article_id1 = Setup_article_production1.article_id LEFT OUTER JOIN
                      dbo.Setup_article_production AS Setup_article_production2 ON dbo.master_lotsmaking.article_id2 = Setup_article_production2.article_id LEFT OUTER JOIN
                      dbo.Setup_article_production AS Setup_article_production3 ON dbo.master_lotsmaking.article_id3 = Setup_article_production3.article_id LEFT OUTER JOIN
                      dbo.Setup_article_production AS Setup_article_production4 ON dbo.master_lotsmaking.article_id4 = Setup_article_production4.article_id LEFT OUTER JOIN
                      dbo.Setup_article_production AS Setup_article_production5 ON dbo.master_lotsmaking.article_id5 = Setup_article_production5.article_id

---