From clause 'Select * from table@ a '

Tools & Utilities
Enthusiast

From clause 'Select * from table@ a '

Does anybody know what the significance of the @ sign is in the following Teradata SQL?

SELECT
COALESCE(a.LISTED_TN_NPA, 'D8'XC) LISTED_TN_NPA,
COALESCE(a.LISTED_TN_COP, 'D8'XC) LISTED_TN_COP,
COALESCE(TRIM(b.ZIP_FIVE),' ') ZIP_FIVE,

CASE COALESCE(c.COMMUNITY_ID, -1) WHEN -1 THEN COALESCE(TRIM(Upper(b.STATE_OVERRIDE)),' ') ELSE COALESCE(TRIM(Upper(c.STATE_ABBR)),' ') END,

CASE COALESCE(g.code_value, '-1') WHEN '-1' THEN 'LISTING PROFILE UNRESOLVED' ELSE COALESCE(TRIM(Upper(g.decode_display)), 'D8'XC) END

FROM LISTING@ a, ADDRESS@ b, COMMUNITY@ c,
(Select * from domain_decodes@ where domain_code = 'GNSTATEABBR') g
Where
(a.LISTED_ADDRESS_ID = b.ADDRESS_ID (+))
and b.COMMUNITY_ID= c.COMMUNITY_ID (+)
1 REPLY
Teradata Employee

Re: From clause 'Select * from table@ a '

It's not Teradata SQL. I'm guessing it's Oracle, since it has the (+) modifiers for outer join.