SQL without sub selects (Newbi)

[healdp]

Hi All..
Im new to the world of PHP and SQL so I expect I shall be visiting here quite often!

Anyway Im sure this is simple, but it seems to be causing me problems.
I have the following SQL,
$SQL = "select LibraryID,Title,Format from Library where LendStatus = 1 AND LenderID IN (select LenderID from lender where AccountID = $_SESSION[userID])"

The problem is that MySQL3.2 does not support the sub select.
My question is, How can I re write this without using the sub select??

I do hope someone can help!
Many thanks in advance

Phill

[Danicek]

Select Library.LibraryID, Library.Title, Library.Format
from Library, lender
where Library.LendStatus = 1
AND Library.LenderID = lender.LenderID
and lender.AccountID = $_SESSION[userID]