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

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

    I was using INNER JOIN mostly with "ON =" 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...


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

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