invalid identifier
kama021Feb 2 2010 — edited Feb 2 2010SELECT DECODE (b.id, (SELECT firstnameId
FROM tablec a
WHERE a.id = 'ABC'), a.DisplayName, 'Unknown Id')
FROM tabula b
Above is a script to get the names of my customers by using decode and i get the error a.DisplayName invalid identifier.
any help using a select in a decode?