wkempees
Posts: 1679
|
| Posted: 06/12/2008, 3:54 PM |
|
What Database, what version?
More important what is the delete you are after:
Delete from (1) apply, delete from (2) both tables?
Case 1:rewrite it as
delete from apply
where apply.mid= { select mid from rbase where mid='fc2de981ec293ad3cf439fd6b821b061')
or as
delete apply.* from apply,rbase
where apply.mid=rbase=.mid and mid='fc2de981ec293ad3cf439fd6b821b061'
Case 2:
delete apply.*, rbase.* from apply,rbase
where apply.mid=rbase=.mid and mid='fc2de981ec293ad3cf439fd6b821b061'
(MySQL 4+, Probably Access as well)
Think you are after Case 2
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
