Allow sql keyword "join" to refer to "inner join"
"inner join" is the most commonly used join in sql statements. Allow just the word "join" to refer to an "inner join" will cut down the time to type sql statements. This syntax is also supported by MS SQL Server and will cut down the time for users of MS SQL Server to migrate their SQL statements to ADS.
Rafick
shared this idea
Looks like this was already implemented in ADS v9.0
3 comments
-
joachimd
commented
IIRC SQLAny supports KEY JOIN. Another nice enhancement for lazy programmers. If there's an RI, you don't need to specify the JOIN fields any more:
select a.*, b.* from tablea a key join tableb b
instead of
select a.*, b.* from tablea a left outer join tableb b on a.id=b.a_id
-
joshery
commented
Just FYI... INNER JOIN is implied in a WHERE SELECT statement (so you don't need the words at all). For example:
SELECT * FROM <left>,<right> WHERE <cond> is the same as
SELECT * FROM <left> INNER JOIN <right> ON <cond> -
jeremym1234
commented
Thanks, makes sense. I've marked this as planned.
