Delete records which has referance to the same able

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?? Received on Mon Aug 28 2006 - 07:52:47 CDT