ANSI SQL 2012 . Is INNER required 1

[Dimitrie1]

I've been told I need to bring all my SQL code up to ANSI standard before we move to SQL 2012.

Currently most of my joins are defined in a JOIN statement and not the WHERE clause.

my question is can I just say
TABLE1 JOIN TABLE2
ON ....
or
must I say
TABLE1 INNER JOIN TABLE2
ON ....

also do I need the word OUTER or can I just say LEFT JOIN, RIGHT JOIN .

Even if it's not required but is recommended that would help as we could make the changes after upgrade at a slower pace and not rushed.

Linda

 

[fredericofonseca]

it is a question of standard - look at it this way - if you see word "join" is it immediately clear to all developers that it is a inner join or do some need to think what is the default join type? so while not mandatory many consider it a must because of the above reason.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Dimitrie1]

Perfect thank You.

if it is not mandatory then we can still do it but not have to race to meet a quick deadline

Linda