Why is the ( ) mandatory in the SQL statement select * from gifts INNER JOIN sentgifts using (giftID

Posted by Jian Lin on Stack Overflow See other posts from Stack Overflow or by Jian Lin
Published on 2010-04-24T13:22:33Z Indexed on 2010/04/24 13:23 UTC
Read the original article Hit count: 293

Filed under:
|
|
|

Why is the ( ) mandatory in the SQL statement

select * from gifts INNER JOIN sentgifts using (giftID); 

? The ( ) usually is for specifying grouping of something. But in this case, are we supposed to be able to use 2 or more field names... in the example above, it can be all clear that it is 1 field, is it just that the parser is not made to bypass the ( ) when it is all clear? (such as in the language Ruby).

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql