Can the thing be accomplished in a single Query?
Posted on 2004-10-18
I have three tables
key1 from Table1 is used as a foreign key in Table2 and key3 from Table2 is used as a foreign key in Table3. I need to delete from T1 all rows where key1 = 0 . For this I ll have to delete the respective foreign key enteries from T2 and T3. Whether the whole thing could be accomplished in a single query?? or at the most two queries? Helps in this regard appreciated.