Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    8

    Unanswered: is USING keyword in INNER JOIN over ON keyword SQL compatible ?

    I was using INNER JOIN mostly with "ON table1.id = table2.id" syntax but i can see that MySQL supports the shorter "USING(id)" notation. However I would like to use a SQL compatible syntax. Is USING part of any SQL standard specs ? Couldn't find any info on MySQL manual...

    AMn

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    both are part of the standard

    if you ever have questions about the standard, consult the Mimer Validator
    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
  •