Selectively delete entries from two tables

[murukessan]

Hello everyone,
Consider two tables A and B
A
no year
1 2000
2 2001
3 2000
4 2002

B
no
1
1
1
2
2
3
3
4

What i want to do is delete from A all those entries that have "year" field as "2000" and before doing so i want to delete all the entries in B those "no" field matches the "no" field of A where its "year" column is "2000"

What i want after the operations is the following set of tables
A
no year
2 2001
4 2002

B
no
2
2
4




Thanks in advance
murukessan

[John_G]

Using SQL:

First: "Delete from B where [No] in (Select [No] from A where [year] = 2000)"
then
"Delete from A where [Year] = 2000"

John

[murukessan]

Thanks a lot for your response

[murukessan]

It worked well thanks again....muru