Software Engineer, Blogger, Gadgets, Sports, Circket, Movies and Gamer.
Here is how we can delete using JOINS. I have used inner join here.
DELETETable1FROMTable1 INNER JOIN Table2ON Table1.Field2 = Table2.Field2WHERE -- YOUR WHERE CONDITIONSTable2.Field3 IS NOT NULL
No comments:
Post a Comment