![]() |
#2
purana2007-12-17 17:45
|
select CRM_Event_tb.*,CRM_Pri_tb.PriName,CRM_EventState_tb.EventState ,CRM_Principal_tb.PrincipalName from CRM_Event_tb
left join CRM_Pri_tb on CRM_Pri_tb.id =CRM_Event_tb.PriID
LEFT join CRM_EventState_tb on CRM_EventState_tb.id = CRM_Event_tb.EventStateID
LEFT join CRM_Principal_tb on CRM_Principal_tb.id = CRM_Event_tb.PrincipalID
where AbstractExplain like '%@AbstractExplain%'