• David Portas (11/26/2009)


    Relational queries preserve keys in their results, ...

    I've been trying figure this out for a week now, and I just can't see how this is true. How can a relational query "preserve keys" across relational operations like PROJECT and JOIN? It just doesn't work as far as I can tell, even SELECT is questionable. Granted, there may be some subtlety that I am missing that allows it for JOIN (if so please let me know). But PROJECT seem plainly impossible, given that one or more of the key columns could be removed and that you cannot validly derive keys merely from data inferencing.

    :crazy:

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]