sql - The multi-part identifier "" could not be bound. error on sqlserver -

sql - The multi-part identifier "" could not be bound. error on sqlserver -

i write query on sql server. here tthe query..

insert #tempr( nqtyr , cbenor , dbedater , nreceivevaluer , cremarksr , njoborderdtlidr , nskuidr , cskucoder , cskudescriptionr, njoborderidr , cjobordernor , nlocationidr , loccoder, nwtr , nvolr , cstatusr, nasnidr, cpalletidr ) select sum(wms_inventorytag.ncount) nqtyr, isnull(wms_outturndtl.cbeno,'') cbenor, wms_outturndtl.dbedate dbedater, isnull(wms_outturndtl.nreceivevalue,0) nreceivevaluer, '' cremarks, wms_joborderdtl.njoborderdtlid njoborderdtlidr, wms_skumst.nskuid nskuidr, wms_skumst.cskucode cskucoder, wms_skumst.cskudescription cskudescriptionr, wms_joborder.njoborderid njoborderidr, wms_joborder.cjoborderno cjobordernor, wms_loactionmst.nlocationid nlocationidr, wms_loactionmst.nlocationcode loccoder, wms_joborderdtl.nwt nwtr, wms_joborderdtl.nvol nvolr, wms_joborder.cstatus cstatusr, wms_joborderdtl.nasnid nasnidr, wms_outturndtl.cpalletid cpalletidr wms_inventorytrans inner bring together wms_outturndtl on wms_outturndtl.noutturndtlid = wms_inventorytrans.noutturndtlid inner bring together wms_joborderdtl on wms_inventorytrans.njoborderdtlid = wms_joborderdtl.njoborderdtlid inner bring together wms_skumst on wms_joborderdtl.nskuid = wms_skumst.nskuid inner bring together wms_joborder on wms_joborderdtl.njoborderid = wms_joborder.njoborderid inner bring together wms_warehousemst on wms_warehousemst.nwarehouseid=wms_joborder.nwarehouseid inner bring together wms_inventorytag on wms_inventorytrans.ninvtransid=wms_inventorytag.ninvtransid inner bring together wms_loactionmst on wms_inventorytag.nlocationid=wms_loactionmst.nlocationid wms_joborder.cstatus='a' , wms_inventorytag.cstatus='a' , 1=case when isnull(@jobid,'')='' 1 else case when wms_joborder.njoborderid=@jobid 1 else 0 end end , 1=case when isnull(@custid,'')='' 1 else case when wms_joborder.ncustomer=@custid 1 else 0 end end , 1=case when isnull(@locid,'')='' 1 else case when wms_loactionmst.nlocationid=@locid 1 else 0 end end , 1=case when isnull(@asnid,'')='' 1 else case when wms_joborderdtl.nasnid=@asnid 1 else 0 end end , wms_joborder.nwarehouseid=@warehouseid grouping wms_outturndtl.cbeno, wms_outturndtl.dbedate, isnull(wms_outturndtl.nreceivevalue,0), wms_joborderdtl.njoborderdtlid, wms_skumst.nskuid, wms_skumst.cskucode, wms_skumst.cskudescription, wms_joborder.njoborderid, wms_joborder.cjoborderno,wms_loactionmst.nlocationid,wms_loactionmst.nlocationcode,wms_joborder.cstatus, wms_joborderdtl.nwt, wms_joborderdtl.nvol,wms_joborderdtl.nasnid,wms_outturndtl.cpalletid order wms_joborder.njoborderid

but when excecuting query returns error messege

the multi-part identifier "wms_outturndtl.cpalletid" not bound.

i have thought do.

check wms_outturndtl table. , check columns right

sql sql-server stored-procedures