Re: subquery to join

[Jorgen Nilsson]

Oops, this is the query I'm wondering over :)

SELECT p.pollID, p.thepoll, a.answerID, a.answer
FROM polls AS p
JOIN pollAnswer AS a
ON p.pollID = a.pollID
WHERE p.pollID = (SELECT MAX(pollID) FROM polls);