Regarding Mysql Query

Hi,

I have 2 tables events & groups and i wanna search this both table using keyword based on event n group name . my problem is to fetch both tables result in a single query along with user table joined within this query. I cant use UNION bcoz both event n group havin different fields.anyone help me out to fix this .

Thanks in advance,