Now this is complex SQL and it don't work

[Salient]

 sSQL = "SELECT B.BookID, B.BookTitle, B.Book.SubTitle, C.CategoryName, R.FirstName, R.LastName, " _
        & "P.PublisherName, B.DateSent, B.DateReceived, B.DateRequested, B.DateReturned, " _
        & "B.JournalMonth, B.Reviewed FROM Books AS B " _
        & "INNER JOIN Category AS C ON C.CategoryID=B.CategoryID " _
        & "INNER JOIN Reviewers AS R ON R.ReviewerID=B.ReviewerID " _
        & "INNER JOIN Publishers AS P ON P.PublisherID=B.Distributor " _
        & "WHERE DateSent NOT NULL AND DateReturned IS NULL ORDER BY BookTitle"

Error looks to be in the INNER JOIN stuff may not have that excatly right. Mind think I am also getting the NOT NULL mixed up with IBM db syntax but haven't been able to find an example on how to test for something having a value in an SQL statement.