View Single Post
  #15 (permalink)  
Old 08-04-10, 04:17
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by holsen32 View Post
You have created a “Cats 22”.
i completely agree with your point, that a true 1-to-1 relationship is impossible because you cannot enter values on both sides simultaneously (and therefore it has to be a 1-to-0-or-1 relationship)

i would just like to mention that this is called "catch 22" not "cats 22" -- it is named after an idea in a book with that actual title, "catch 22"

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote