Page 1 of 2 12 LastLast
Results 1 to 15 of 23

Thread: Join

  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unanswered: Join

    I have a simple question.
    Is there any difference in LEFT JOIN and LFET OUTTER JOIN?
    I mean if I write LEFT JOIN instead of LFET OUTTER JOIN will there be any change?

  2. #2
    Join Date
    Mar 2004
    Posts
    80
    no difference

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    If you use a LFET OUTTER JOIN in your query instead of a LEFT JOIN ... your query will return a syntax error .... it would be OK if you used LEFT OUTER join in your query ....

    No difference in between LEFT OUTER JOIN or LEFT JOIN though.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Hmm... how 'bout LEPHT OWDER JOYN?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    I could have used that but the procedure specs clearly mention to use a "LFET OUTTER JOIN"
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    subhasishray, don't listen to those guys, they are just teasing

    the answer is, reverse the order of your tables and then use WRITE OUTER JOIN
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Nobody uses WRITE OUTER JOINs anymore, Rudy. He's better off linking his tables in the WEAR clause.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Huh .... So I write outer join and that will do it ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by blindman
    Nobody uses WRITE OUTER JOINs anymore, Rudy.
    of course they do

    but only in non-UNION shops
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    He he ... And I thought Non-UNION shops had been TRUNCATED a long time ago
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  11. #11
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Nope. Businesses are afraid to get CROSS with UNIONs.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    So what's the difference then between an INNER JOIN and a BULK INSERT?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    an INNER JOIN is obtained only in marriage

    a BULK INSERT is pr0n
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  14. #14
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Good lord !!! I never thought of it that way ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    In Massachusetts, you can now obtain a CROSS JOIN in marriage too.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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