Created
July 29, 2008 05:59
-
-
Save SQLlover/3029 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select zvn.nr | |
,zvp.datum_ingang | |
,zvp.datum_einde | |
,zvn.soort_voornemen | |
,zvp.status | |
,zvn.r_cli_rel_nr | |
,elv.code | |
,elv.oms | |
from geb_voornemen_elementen vot | |
inner join ref_elementaire_verg_elementen elv | |
on vot.elv_code = elv.code | |
inner join geb_zorg_voornemen_periodes zvp | |
on vot.zvp_zvn_nr = zvp.zvn_nr | |
and vot.zvp_volgnr = zvp.volgnr | |
inner join geb_zorg_voornemens zvn | |
on zvp.zvn_nr = zvn.nr | |
where 1=1 | |
and elv.soort_codering = '85' | |
and ( regexp_like(elv.oms,'rolstoel') | |
or | |
regexp_like(elv.oms,'Visueel') | |
or | |
regexp_like(elv.oms,'Hardheidsclausule' ) | |
or | |
regexp_like(elv.oms,'Aanvul') | |
or | |
regexp_like(elv.oms,'Chemo') | |
or | |
regexp_like(elv.oms,'Nier') | |
) | |
and zvp.datum_ingang >= to_date('01-01-2006','dd-mm-yyyy') | |
and zvp.datum_ingang < to_date('01-01-2008','dd-mm-yyyy') | |
and zvn.nr = 630978 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment