代码如下

DELETE aFROM t_StorageQty aLEFT JOIN t_Item bON a.F_ItemID = b.F_IDWHERE isnull(b.F_ID,‘‘) = ‘‘