'Best way to select related items from two separate tables

I looked at some S/O posts and am not getting it. I think I can do this without needing to use JOIN.

I have 2 tables:

pagecontents : content, pages_id
pages        : id, title

Of course there is a simple relation here, as pagecontents.pages_id is always the same as pages.id.

I'm submitting a search with the query below:

SELECT `pages_id`, 
MATCH(`content`) AGAINST('search term' IN BOOLEAN MODE) AS score 
FROM `pagecontents` 
WHERE 
MATCH(`content`) AGAINST ('search term' IN BOOLEAN MODE) 
ORDER BY score DESC;

The query returns results as expected, but:

My problem I want to get the pages.title for each of the search result set rows. I can't figure out how, and I think it's probably something really easy.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source