Exclude records if exist in abandoned table? 1

[AshleyRickards]

I'm exporting a table but I want to exclude certain records if they exist in my Abandoned table. What would SQL syntax be?

Thanks. Ashley L Rickards
SQL DBA

 

[tlbroadbent]

One way to do it is like this. The RecID would be replaced with the column or columns that define the relationship between the tables.

Select a.*
From TblName As t
Left Join Abandoned As a
On t.RecID=a.RecID
Where a.RecID Is Null Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[AshleyRickards]

Thanks Terry, I'll give a try. Ashley L Rickards
SQL DBA

 

[AshleyRickards]

this is the statement I used and worked perfectly. Thanks again.


SELECT t.*
FROM dbo.Targus_Return t LEFT OUTER JOIN
EIC_ADMIN.TargusAbandoned a ON t.CallId = a.Callid
WHERE (a.Callid IS NULL) AND (t.Status = '2') OR
(t.Status = '3')
Ashley L Rickards
SQL DBA