Phill, thank you so much for that. The query ran perfectly in 10 seconds!

Thank you everyone for your contributions.

Hi guys. Thanks for your ideas. Phill, I tried the double FROM and couldn't get that to work either - it gives me the syntax error near 'del' as it...

Thank you PW. However the exists query does not work. It does not allow you to use an alias for the table to be deleted, as this gives the error...

Thanks Jeff.

I have been trying different queries to see what I can get from the rdb view, and have actually managed to get what I want. However it is...