SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    php_penguin
    SitePoint Community Guest

    Simply SQL: The FROM Clause

    Notice: This is a discussion thread for comments about the SitePoint article, Simply SQL: The FROM Clause.
    __________

    Thanks very much for this - shared it with people on my COMP SCI course rather than having to explain the JOIN stuff myself, saved me lots of hassle!

  2. #2
    SitePoint Enthusiast thenk83's Avatar
    Join Date
    Sep 2005
    Location
    Hacienda Heights, CA
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Good read Rudy!

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,350
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    thanks!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    One website at a time mmj's Avatar
    Join Date
    Feb 2001
    Location
    Melbourne Australia
    Posts
    6,282
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I reckon that is a really good explanation of the different join types. Really clear.

    Years ago I would have appreciated that kind of explanation. It took me a fair bit of research and experimentation to figure out the difference between an inner join and a left (outer) join any why my queries were returning rows even when there was no match in table B.

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,350
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by mmj View Post
    Years ago I would have appreciated that kind of explanation.
    two years ago, it was posted here: http://www.sitepoint.com/forums/show...2&postcount=18

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    One website at a time mmj's Avatar
    Join Date
    Feb 2001
    Location
    Melbourne Australia
    Posts
    6,282
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    two years ago, it was posted here: http://www.sitepoint.com/forums/show...2&postcount=18

    I was learning this stuff back in 2001 unfortunately.

    Also, I think that the diagrams really help the explanation
    [mmj] My magic jigsaw
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    The Bit Depth Blog Twitter Contact me
    Neon Javascript Framework Jokes Android stuff


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
  •