HTMLDB Engine : Oracle Apex
Alles in HTMLDB, Applikationen, Berichte, SQL ...
Re: werteliste filtern
geschrieben von:
christian_goto (---.dip0.t-ipconnect.de)
Datum:
danke für die antwort,habs so hinbekommen:
select display_value,return_value FROM (
select MA.NAME||', '||MA.VORNAME display_value, MA.ID return_value
from MA
where
(:P37_ID IS NULL AND MA.ID NOT IN (SELECT MA_ID FROM DOC_SCAN)) OR
(:P37_ID IS NOT NULL AND MA.ID=:P37_MA_ID)
)
order by 1
select display_value,return_value FROM (
select MA.NAME||', '||MA.VORNAME display_value, MA.ID return_value
from MA
where
(:P37_ID IS NULL AND MA.ID NOT IN (SELECT MA_ID FROM DOC_SCAN)) OR
(:P37_ID IS NOT NULL AND MA.ID=:P37_MA_ID)
)
order by 1
| Thema | Neugierige | geschrieben von | geschrieben |
|---|---|---|---|
 werteliste filtern
|
2645 | christian_goto | |
|
Re: werteliste filtern
|
1301 | FrankLehmann | |
|
Re: werteliste filtern |
1676 | christian_goto |