[help] Query from two tables?

I’m wondering how to go about this? I’m not sure if its even possible or if I need to use a join or something?

Im using a search facility on my page. When a user types something into the search box I need it to search inside two separate tables. Can this be done?

The results for the query will be run inside a while statement.

For the one table I will need to find users names and the other one picture titles.

I would really appreciate any help?