Results 1 to 2 of 2

Thread: How best to use the JOIN command in MySQL

  1. #1
    Join Date
    Sep 2007
    Location
    Maui
    Posts
    602
    Thanks
    266
    Thanked 13 Times in 13 Posts

    Default How best to use the JOIN command in MySQL

    Removed
    Last edited by kuau; 02-09-2010 at 10:45 PM. Reason: must have been a dumb question

  2. #2
    Join Date
    Feb 2010
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    In MySQL, CROSS JOIN is a syntactic equivalent to INNER JOIN (they can replace each other). In standard SQL, they are not equivalent. INNER JOIN is used with an ON clause, CROSS JOIN is used otherwise.

    For more information visit http://dev.mysql.com/doc/refman/5.0/en/join.html

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
  •