sql - Multirow return Query MSACCESS -

sql - Multirow return Query MSACCESS -

i need run query returns events has electrophysiology study don't have %ablation% in case should receive events 608 , 612. table has 2 columns ss_event_ep_id , studyprocedure

screenshot of tables https://plus.google.com/photos/105880715521229058253/albums/6026235567691005409/6026235568072337762

i saw tables. yes correct, need subquery.

what need exists operator well.

select ep.ss_event_ep_id, ep.studyprocedure, event_ep.eventdate event_ep inner bring together ep_procedure ep on event_ep.ss_event_ep_id = ep.ss_event_ep_id ep.studyprocedure = "electrophysiology study" , (event_ep.eventdate between #1/1/2004# , #12/31/2012#) , not exists ( select ss_event_ep_id ep_procedure ep_i ep_i.ss_event_ep_id = ep.ss_event_ep_id , ep_i.studyprocedure "%blation%" )

sql multirow