MySQL从不同的表中检索2个值

Question

I didn't know how to explain it in so few words as to fit it in the title. However it's not really complicated. I have 2 tables, the first called "Lines" has these 2 columns:

Text  PID

and the second called Poems these 2:

PID Title

I need to SELECT rows from the first table when they are equal to $something and then look up on the table Poems for the matching row (the one that has the same PID) and display both the Text from the first table and the Title from the second.

How can this be done? Thanks

Answer 1

SELECT Lines.*, Poems.* FROM Lines 
INNER JOIN Poems ON(Poems.PID = Lines.PID)
WHERE Lines.Text = 'SOME VALUE'