Code:
SELECT stories.give, stories.list, stories.of, stories.fields, categories.wanted
FROM stories INNER JOIN categories
ON stories.catid = categories.catid
WHERE categories.name LIKE '%racing%'
AND stories.name LIKE '%racint%'
Or use an "implicit join", thus:
Code:
SELECT stories.give, stories.list, stories.of, stories.fields, categories.wanted
FROM stories, categories
WHERE stories.catid = categories.catid
AND categories.name LIKE '%racing%'
AND stories.name LIKE '%racint%'
And/or use aliases on your table names to make shorter queries, thus:
Code:
SELECT S.give, S.list, S.of, S.fields, C.wanted
FROM stories AS S, categories AS C
WHERE S.catid = C.catid
AND C.name LIKE '%racing%'
AND S.name LIKE '%racint%'
Or or or or ...