Skip to content

Instantly share code, notes, and snippets.

@SQLlover
Created July 29, 2008 05:59
Show Gist options
  • Save SQLlover/3029 to your computer and use it in GitHub Desktop.
Save SQLlover/3029 to your computer and use it in GitHub Desktop.
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