Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    104

    n00b question on linking table

    I have the table owners and the table stands, with PKs ownerID and standID respectively. They have a m-to-m relationship, so I want to link them with a linking table.

    Am I correct in thinking that these tables do NOT need foreign keys from their respective other table? That is, the owners table does not need the foreign key, standID and the stands table doesn't need the ownerID foreign key, if my objective is to link the two through a linking table.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Yes.

    -PatP

  3. #3
    Join Date
    Feb 2009
    Posts
    104

    thanks

    Thanks. This stuff is starting to sink in.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by rbfree
    This stuff is starting to sink in.
    you been saying that for weeks

    just how deep are you expecting it to sink?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2009
    Posts
    104
    Keep in mind that the natural densification process started long ago, with me. And, my temporal reference is geological time. So, "starting to sink in" can be a long, long process.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •