修改销货单开票码sql

UPDATE COPTH SET TH026='Y' FROM COPTH LEFT JOIN COPTG ON TG001=TH001 AND TG002=TH002 WHERE TH026='N' AND TG003>='20130601' AND TG003<='20130630' AND TG001='2360' AND TG023='Y' AND TG002 NOT IN ('130629009','130625003','130619002','130601006')