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