SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    gimme the uuuuuuuuuuu duuudie's Avatar
    Join Date
    Feb 2004
    Location
    Switzerland
    Posts
    2,253
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    lookup table or foreign key?

    Hi
    What is the best way to join two sets of data?

    Foreign keys?

    Or a lookup table (whose only purpose would be to link data) with cols like:

    table1_id table2_id

    thanks in advance for your advice

  2. #2
    SitePoint Addict Guimauve's Avatar
    Join Date
    Aug 2004
    Location
    Chicago
    Posts
    255
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Both...

    If you create a lookup table you will have to put a foreign key relationship from the table that uses the values from the lookup table.

  3. #3
    gimme the uuuuuuuuuuu duuudie's Avatar
    Join Date
    Feb 2004
    Location
    Switzerland
    Posts
    2,253
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok

    thanks.


Bookmarks

Posting Permissions

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