Toad World® Forums

I need the value of a field as Result value as part of DECODE func in bold


#1

10/16/2009 2:09:11 PM 0:00:01.203: Toad for Data Analysts: ORA-00904: “T2”.“PROVSVCCATRATING”: invalid identifier

GENTIVA_BRANCH_COVERAGE.sql:8:431: SELECT DISTINCT

T2.BRANCHNUMB,

T2.PROVID,

T2.FEDERALTAXID,

FROM TBLPROVIDERSVCCATEGORY T1, TBLPROV T2

I tried a case statement instead but no success
I appreciate your help thank you

but getting an error""
the script as follows:-
SELECT DISTINCT T2.PROVPARENTID,T2.PROVNAME AS BranchName,DECODE (T1.SERVICECATID,‘RESP’, T2.PROVSVCCATRATING, NULL) AS RESPWHERE T1.PROVID = T2.PROVID


#2

Your decode looks fine.
Is “T2”.“PROVSVCCATRATING” a valid column?

Debbie


#3

oopsi silly me yes it will be a vaslid column if it was under T1 and not T2 sorry about that a nd thank you