Select v.ID
,v.greeting
,v.mid
,v.edi

from verses.dbo.verse v 
inner join verses.dbo.events e ON e.edi = v.edi

SELECT v.ID,
       v.greeting,
       v.mid,
       v.eid,
       e.Event_Type,
       s.Event_Sub_Type
FROM   verses.dbo.verse v
       INNER JOIN verses.dbo.events e
            ON  e.eid = v.eid
       INNER JOIN verses.dbo.Event_Sub s
	         ON s.Eid = e.Eid;

Select v.ID
,v.greeting
,v.mid
,v.edi
,e.event_type
,es.event_sub_type

from verses.dbo.verse v 
inner join verses.dbo.events e ON e.edi = v.edi
inner join verses.dbo.event_sub es ON es.edi = v.edi -- assuming there is an edi column in this table

where es.mid_value = 'coconut'