Results 1 to 2 of 2

Thread: Bridge table ?

  1. #1
    Join Date
    Dec 2010
    Posts
    3

    Unanswered: Bridge table ?

    New to the forum.. need to be able to create a bridge table lets call it xxx
    between two other tables... lets say AAA and BBB so that it would look something like this AAA XXX BBB can someone please help me ?Thank you

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
    CREATE TABLE xxx
    ( aaa_id INTEGER NOT NULL 
    , bbb_id INTEGER NOT NULL 
    , PRIMARY KEY (aaa_id,bbb_id)
    );
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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