A>SELECT c_event.d_ev, 
A>c_event.c_event,
A>C_EVENT.c_cus_se c_custom,
A>c_event.c_event
A>m_doc_sr.customer
A>FROM (select m_doc_sr.c_event, lpu.customer from ic_as.dbo.m_doc_sr, ic_as.dbo.c_custom lpu 
A>where m_doc_sr.c_cus_my = LPU.c_custom) m_doc_sr_1,
A>dbo.c_event
A>WHERE m_doc_sr_1.c_event =* c_event.c_event
A>