Searching 2 tables at the same time

[lukep11a]

Hi, does anybody know whether it is possible to search 2 tables from a database at once?

[codefossa]

SQL function JOIN

[lukep11a]

Thanks, so if I wanted to search two tables where a particular row from each table was equal to the query and then display results from both tables how would i go about that, I have this code which i know is incorrect but it may help you to understand what i am after..

 

$query = "SELECT * FROM names, directory WHERE names.surname, directory.surname LIKE \"%$trimmed%\" ORDER by surname";