Results 1 to 3 of 3

Thread: sql

  1. #1
    Join Date
    Apr 2010
    Posts
    2

    Question sql

    hw foreign key and primary key related to each others

    whats diff. b/w equi-joins&non equi-joins

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    What did you find when you looked up these terms?

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by bkvineet View Post
    hw foreign key and primary key related to each others
    how?

    they are related through the REFERENCES syntax of the foreign key declaration


    Quote Originally Posted by bkvineet View Post
    whats diff. b/w equi-joins&non equi-joins
    this is easy

    equi-joins match rows based on some column values being equal, while non equi-joins match rows based on some column values ~not~ being equal
    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
  •