删除包含外键的行在SQL中不显示任何结果

我用SQL调用了一个表 address

id, subid, country, state, city

保存在子id包含其父id的行中的每个区域。

我加入这一行如下:

SELECT  
    [Address].country AS Parent, p.country AS state,
    c.country AS city, h.country AS hamlet
FROM 
    [Address] p  
LEFT JOIN
    [Address] ON p.subid = [Address].id 
LEFT OUTER JOIN
    [Address] c ON c.subid = p.id 
LEFT OUTER JOIN
    [Address] h ON h.subid = c.id

但当删除任何区域时,不会显示任何结果。有人能帮我吗?

删除查询:

delete from address where country = '" & TreeView1.SelectedNode.Text.ToString & "' and tag='country