Delete row which contains foreign key dont display any result in SQL

Asked Oct 17 '18 at 12:42

Active Oct 17 '18 at 18:36

Viewed 73 times

I have table in SQL called address which has columns

id, subid, country, state, city

Each region saved in row which subid contain the id of its parent.

I joined this row as follow:

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

But when delete any region no results are displayed. Can anyone help me please?

Deletion Query:

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

edited Oct 17 '18 at 18:36

websch01ar

2,103
2
13
22

asked Oct 17 '18 at 12:42

ahmed elgohary

1

Can you please share your delete query? – Mayank Porwal Oct 17 '18 at 13:15
delete from address where country = '" & TreeView1.SelectedNode.Text.ToString & "' and tag='country – ahmed elgohary Oct 17 '18 at 13:20
You don't use parameters? That's evil... – muffi Oct 17 '18 at 13:42
1

Delete row from where? What results are you expecting from a delete? – Crowcoder Oct 17 '18 at 14:42
Would it be possible to include a snippet of data so we can infer the relationships ourselves as well as the schema for the Address table. – websch01ar Oct 17 '18 at 16:25

Delete row which contains foreign key dont display any result in SQL

0 Answers0