delete query

Article View: be.comp.programming

Article #2776

Back to be.comp.programming Previous Next

#2776

From: Snuyt
Date: Tue, 16 Mar 2004 17:53

26 lines
1373 bytes

Hallo

stel, je hebt 2 tabellen (access, maar dat speelt hier geen rol):

tabel1
id	autonumber
str	text

tabel2
id	autonumber
T1_id	number


Ik wil nu uit tabel1 die records verwijderen met str="String" EN uit 
tabel2 de overeenkomstige records (dus met T1_id=id van tabel1)


dus iets in de aard van:

DELETE FROM tabel1 t, tabel2 u WHERE t.str='String' AND t.id=u.T1_id

maar dat werkt dus niet. Weet er iemand de goede manier om dit te doen?


bedankt,
	Snuyt

Technical Details

Message-ID: <40573f14$0$1929$ba620e4c@news.skynet.be>

Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!skynet.be!skynet.be!louie!tjb!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,c7b9d98a48f26ed0,start
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2004-03-16 09:53:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!skynet.be!skynet.be!louie!tjb!not-for-mail
Date: Tue, 16 Mar 2004 18:53:32 +0100
From: Snuyt <snuyt_nospam@skynet.be>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: be.comp.programming
Subject: delete query
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 26
Message-ID: <40573f14$0$1929$ba620e4c@news.skynet.be>
Organization: -= Belgacom Usenet Service =-
NNTP-Posting-Host: 80.200.32.61
X-Trace: 1079459604 reader3.news.skynet.be 1929 80.200.32.61:11313
X-Complaints-To: usenet-abuse@skynet.be