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

Amn · #1 (**permalink**) 11-28-04, 08:59

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

r937 · #2 (**permalink**) 11-28-04, 11:13

both are part of the standard

if you ever have questions about the standard, consult the Mimer Validator

Internet Services

Web Development

Digital Marketing

Consumer Tech