Help with Oracle Query

Posted by Gnaniyar Zubair on Stack Overflow See other posts from Stack Overflow or by Gnaniyar Zubair
Published on 2010-04-21T08:44:18Z Indexed on 2010/04/21 12:53 UTC
Read the original article Hit count: 387

Filed under:
|
|

I want to delete all the records where field name class="10010" from Table A and AentryId = BentryId from Table B.

if i delete the entryId 12 which matches className=10010 from Table A and the same time that same id should delete from Table B also.

Table A:

AentryId  className     
12      10010
13      10011
14      10010
15      10011

Table B:

BentryId  name   
12         xyz
13         abc
14         aaa

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle