Simple database code not working ( Problem ongoing )

[eluser]mdowns[/eluser]
Could you not use the following query? :

SELECT T.* FROM pm_thread AS T
JOIN pm_recipient AS R
WHERE T.pm_id = R.pm_id AND R.pm_recipient = @userid