What will be the effect of the given SQL Query

morfius9 · New User Joined: 22 Feb 2006 Posts: 27

What will the below query achieve?

Delete from A
Where exists
(Select 'F' from B
where B.date = current date)

WARNING: Do not use 'URGENT' in Title

guptae · Posted: Thu Nov 30, 2006 2:39 pm

Hi morfius9,

I think it will delete all the row of table A

Corrections r welcome

muthuvel · Posted: Thu Nov 30, 2006 8:19 pm

Hi,
In order to delete all the rows of table A the exist should have atleast one row selected from table B.If no row is selected ,then there will be no delete.

Correct me if i am wrong.

Regards,
Muthuvel.

guptae · Posted: Thu Nov 30, 2006 8:59 pm

Hi Muthuwel.

Thanks for correcting me

morfius9 · New User Joined: 22 Feb 2006 Posts: 27

Thanks Guys, I appreciate the help