摘要：
create TABLE #TMP (I_SarInfor varchar(10)) -- 创建一个临时表insert into #TMPSELECT A.I_SailorInfoID FROM CERT_SailorLetter A LEFT JOINCREW_SailorInfo BON A.I_SailorInfoID = B.I_SailorInfoIDLEFT JOINCOM_LetterName C ON A.NVC_LetterNameCode = C.NVC_LetterNameCodeLEFT JOINCOM_Position D ON B.NVC_Positi... 阅读全文