Equivalent to SQL join?

I've got an application with a Contacts table and a Journal Entries table with a one-to-many relationship between them (e.g. a contact can have multiple journal entries). The Journal Entries table has a Lookup field on Contacts.ID to accomplish this. I want to provide my users the ability to search for Contacts by Journal Entry. The intent is for somebody to be able to note something about a contact and then later be able to search for them by it. In SQL this would be handled by a JOIN statement, e.g.

SELECT * FROM Contacts JOIN Journal Entries ON Contacts.ID == Journal Entries.contact_id WHERE Journal Entry.note LIKE '%search text%'

How can I accomplish something similar with Zoho?

Thanks,
Kevin