'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 |
|---|
