Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hierarchical SQL Select
Message
From
04/09/2009 08:18:09
John Baird
Coatesville, Pennsylvania, United States
 
 
To
03/09/2009 23:58:48
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01422513
Message ID:
01422621
Views:
54
>The fk refers to the parent pk, right?
>
>If so, is pk 3 supposed to have a fk 2 rather than 1?


No, the adds and deletes point to the same parent. The edits (children) point to the add parent. the reasoning is if you have add rights you probably have edit rights also, but not necessarily delete rights.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform