USE T24D001


UPDATE .DBO.SEND_TO_JOB_ITEM_DETAIL Set RecSrNo=T1.F1, RecISrNo = T1.F2 FROM (
SELECT OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.SrNo AS F1, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.ItemSrNo AS F2, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.ItemName AS F3, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.LotNo AS F4, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.StockType AS F5 FROM OPENING_CHALLAN_RECEIVED_FROM_JOB INNER JOIN OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL ON OPENING_CHALLAN_RECEIVED_FROM_JOB.SrNo = OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.SrNo) as t1
WHERE StockType COLLATE DATABASE_DEFAULT = T1.F5 AND LotNo = T1.F4 AND LEFT(LotNo,1) = '9'