[Solved] Search multiple tables in mySQL database [closed]

Use a join

select *
from user_initials
inner join user_data on user_initials.user = user_data.user
where user_data.user="kashif"