DELETEing orphaned records

Article View: borland.public.interbase.sql

Article #823

Back to borland.public.interbase.sql Previous Next

#823

From: Paul Embleton
Date: Sun, 13 May 2007 08:26

11 lines
1068 bytes

I need to delete records from one table, for which there are no 
corresponding records in a second table. I get 'token unknown LEFT' with 
the following:

DELETE FROM "Tasks" T
LEFT OUTER JOIN "Servers" S 
ON S."ClientName"=T."ClientName" AND S."ServerName"=T."ServerName"
WHERE S."ClientName" IS NULL AND S."ServerName" IS NULL

tia
Paul

Technical Details

Message-ID: <4646cba7@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!news-xxxfer.readnews.com!news-out.readnews.com!transit4.readnews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,917a31690354dae3,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Newsgroups: borland.public.interbase.sql
Subject: DELETEing orphaned records
From: Paul Embleton <reverse_ku.ok.nez@e.a.p>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 217.155.206.177
Message-ID: <4646cba7@newsgroups.borland.com>
Date: 13 May 2007 01:26:15 -0700
X-Trace: newsgroups.borland.com 1179044775 217.155.206.177 (13 May 2007 01:26:15 -0700)
Lines: 11
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!news-xxxfer.readnews.com!news-out.readnews.com!transit4.readnews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail