David B wrote:
> SELECT to_char( created_timestamp, 'DDMMYY' ) AS "joined_on",
<snip>
> r_app.joined_on ; -- HOW do I reference this value?...this does not work
Try either making that first line:
... AS joined_on,
(i.e. without the double quotes) or make the second one:
r_app."joined_on";
(i.e. with double quotes)
HTH,
Joe