Hi all,

Can anyone solve my problem..

i have a table in which the foreign key referance is to another column
in the same table.

Now is there any query to delete both the records the child and the
parent using a single sql query.

the table stucture is as follows

ID, FDB_ID, STD_ID, etc

here FDB_ID id the foreign key for ID


ID FDB_ID ROLL REG_NO ST CD
38 37 364 929560 491 S
37 364 929560 491 F

the second record is the parent and the first is the child

Now i need to delete both the records using a single sql query. Can you
pleas give the query??