Select distinct statement with various alias
504893Jul 3 2007 — edited Jul 3 2007Hi everybody,
I'm trying to put a select distinct statement in a query with two different alias for two different tables; like that:
select distinct a.ma_name||'.'||a.ma_first_name d,
a.ma_first_name||'.'||a.ma_name r
from ma_main a, manager_liste b
where (UPPER(b.manager_first_name||'.'||b.manager_name) = :APP_USER or
(case when 'X'=:APP_USER or 'Y'=:APP_USER
then 1
else 0
end) = 1)
order by a.ma_name
But it doesn't work. Can anybody help?
Thx a lot!
Jan