DELETE
FROM myTable
WHERE parent = 3
Or do you want to be able to recursively delete descendents (i.e. children,
cgrandchildren.) at all levels?
_____
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Thursday, 19 August 2004 8:32 a.m.
To: CF-Talk
Subject: Access SQL Question
Is there a way in access where you can delete all the child of a
parent e.g. if I am deleting a record which a children and
children(s) may or may not have child. Here is db schema
id,name,parent
1,test1,0
2,test2,0
3,test3,1
4,test4,3
any help is appreciated
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
