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: 290
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