Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CASE statement in a join condition

937454Feb 7 2014 — edited Feb 7 2014


Hi,

I am stuck in this part of the code, where I have to use CASE in a join condition. I am working in Teradata so I cannot use "DECODE".

LEFT JOIN V610413.TEAM_ASSIGNMENTS ta

--ON c.firm_id = ta.FirmId

ON CASE WHEN ta.FirmId = c.firm_id THEN ta.FirmId = c.firm_id

  WHEN ta.FirmId <> c.firm_id THEN ta.FirmId = 'No Value'

  END

AND c.stateId = ta.stateId

Please advice

This post has been answered by BrendanP on Feb 7 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2014
Added on Feb 7 2014
5 comments
16,290 views