SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    Non-Member nickthomas25's Avatar
    Join Date
    Dec 2010
    Location
    307-308 JMD Pacific Square
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to use different types of join ..while building connection to the server?

    Hi guys...i was trying to use join for the building my tables properly...but could get as to which table join should i use..please help..me by explaining different types of join and when to use them?

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,495
    Mentioned
    161 Post(s)
    Tagged
    4 Thread(s)
    You don't use joins to build tables. You use them to join tables in a query.
    What join you need to use depends on what you want to achieve.

    MySQL :: MySQL 5.5 Reference Manual :: 12.2.9.1 JOIN Syntax

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,216
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by nickthomas25 View Post
    please help..me by explaining different types of join
    see http://www.sitepoint.com/forums/3234442-post18.html
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    Non-Member nickthomas25's Avatar
    Join Date
    Dec 2010
    Location
    307-308 JMD Pacific Square
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks...buddy this is really helpful...
    but can u tell me different type of normalization as well.....i find them really difficult to learn or understand!!

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,216
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by nickthomas25 View Post
    but can u tell me different type of normalization as well
    i could, but i wouldn't be saying anything new compared to the thousands of tutorials out there already

    just keep searching until you find a good one
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Tags for this Thread

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
  •