Monday, April 23, 2012

Translating oracle right outer join to sql server

I'm fairly new to SQL and I'm trying to translate some oracle commands to sql server. The issue lies with converting the following right outer join:



where
SOURCE_FORMATS.LOC_SIMPLE_ENTITY_ID = FILEFORMAT_INTERNAL_SIGNATURES.LOC_FILEFORMAT_ID (+)


As far as I can understand in SQL this has to be represented in the "from" section to be something like:



from
SIMPLE_ENTITIES "SOURCE_FORMATS" RIGHT OUTER JOIN FILEFORMAT_INTERNAL_SIGNATURES
on SOURCE_FORMATS.LOC_SIMPLE_ENTITY_ID = FILEFORMAT_INTERNAL_SIGNATURES.LOC_FILEFORMAT_ID


Is this logic correct?





No comments:

Post a Comment