Home Forums SQL Server 7,2000 General SQL Construct RE: SQL Construct
noeld
SSC Guru
Points: 96590
More actions
March 2, 2004 at 3:50 pm
#496774
try:
INSERT INTO UNRESOLVED (CaseNbr)
SELECT
T3.CaseNbr
FROM
Table3 T3
LEFT OUTER JOIN
(Select CaseNbr From Table 1
UNION
Select CaseNbr from Table 2
 Q
ON T3.CaseNbr =Q.CaseNbr
WHERE
Q.CaseNbr is Null
* Noel