INSERT INTO TDA•ñ‘‘Ž®M (ƒVƒXƒeƒ€CD, ‰‰KCD, ’ •[‹æ•ª, WŒvCD, WŒv–¼Ì, ‘ÝŽØ, WŒvæ, ‰ÁŒ¸‹æ•ª, ƒ‰ƒCƒ“ƒRƒ“ƒgƒ[ƒ‹, ƒAƒ“ƒ_[ƒ‰ƒCƒ“, ‰E•û•\Ž¦, \¬•\Ž¦, 쬋敪, XVƒvƒƒOƒ‰ƒ€ID, XV“úŽž, —\”õ‚ , —\”õ‚¢, —\”õ‚¤, —\”õ1, —\”õ2, —\”õ3) SELECT B.ƒVƒXƒeƒ€CD, B.‰‰KCD, TDA•ñ‘‘Ž®M.’ •[‹æ•ª, TDA•ñ‘‘Ž®M.WŒvCD, TDA•ñ‘‘Ž®M.WŒv–¼Ì, TDA•ñ‘‘Ž®M.‘ÝŽØ, TDA•ñ‘‘Ž®M.WŒvæ, TDA•ñ‘‘Ž®M.‰ÁŒ¸‹æ•ª, TDA•ñ‘‘Ž®M.ƒ‰ƒCƒ“ƒRƒ“ƒgƒ[ƒ‹, TDA•ñ‘‘Ž®M.ƒAƒ“ƒ_[ƒ‰ƒCƒ“, TDA•ñ‘‘Ž®M.‰E•û•\Ž¦, TDA•ñ‘‘Ž®M.\¬•\Ž¦, TDA•ñ‘‘Ž®M.쬋敪, TDA•ñ‘‘Ž®M.XVƒvƒƒOƒ‰ƒ€ID, TDA•ñ‘‘Ž®M.XV“úŽž, TDA•ñ‘‘Ž®M.—\”õ‚ , TDA•ñ‘‘Ž®M.—\”õ‚¢, TDA•ñ‘‘Ž®M.—\”õ‚¤, TDA•ñ‘‘Ž®M.—\”õ1, TDA•ñ‘‘Ž®M.—\”õ2, TDA•ñ‘‘Ž®M.—\”õ3 FROM (SELECT TC2‰‰KM.ƒVƒXƒeƒ€CD, TC2‰‰KM.‰‰KCD FROM (SELECT ƒVƒXƒeƒ€CD AS ƒVƒXƒeƒ€CD, ‰‰KCD AS ‰‰KCD FROM TDA•ñ‘‘Ž®M GROUP BY ƒVƒXƒeƒ€CD, ‰‰KCD) A RIGHT OUTER JOIN TC2‰‰KM ON A.ƒVƒXƒeƒ€CD = TC2‰‰KM.ƒVƒXƒeƒ€CD AND A.‰‰KCD = TC2‰‰KM.‰‰KCD WHERE (A.‰‰KCD IS NULL)) B CROSS JOIN TDA•ñ‘‘Ž®M WHERE (TDA•ñ‘‘Ž®M.‰‰KCD = 'SYSORIGN')