By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

how query delete

P: n/a
table1
fld1
aa
bb
cc

table2
fld1
aa
cc

after query execute
result table1
table1
fld1
bb

"delete from table1 a where a.fld1=table2.fld1"
but not working
I use access 2000

*** Sent via Developersdex http://www.developersdex.com ***
Aug 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
* tom taol:
table1
fld1
aa
bb
cc

table2
fld1
aa
cc

after query execute
result table1
table1
fld1
bb

"delete from table1 a where a.fld1=table2.fld1"
but not working
I use access 2000

*** Sent via Developersdex http://www.developersdex.com ***
Try:

Delete From Table1 Where fld1 In (Select fld1 From Table2)

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Aug 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.