How to link the column name of foreign key's table on searching in sql query?

How to link the column name of foreign key's table on searching in sql query?

I going to create a search function in my project but found that some
problem in selecting the column record from another foreign key's table is
make me frustrated .
This is a normal sample output before searching:
This is a issued table after searching:
mysql query of my table named "member_booking"
If I'm search the title which is based on event table,it will show me a
string of title record where no restricted by Foreign key.
mysql query may look like this:
select *
from member_booking,event,member
where member_booking.E_ID=event.E_ID and
member_booking.MEM_ID=member.MEM_ID and member_booking.REF_CODES like
'%$keyword%' OR event.E_TITLE like '%$keyword%' OR member.MEM_USERNAME
like '%$keyword%' OR member.MEM_EMAIL like '%$keyword%'
Thanks.