Trying To Join Three Tables

I am fairly new to sql and i am trying to join three tables:

SELECT *
from tbl_RegistrationInfo r JOIN tbl_Ideas i
on r.intRegID = i.intRegID JOIN tbl_Categories c
on i.intCategoryID=c.intCategoryID
where i.intIdeaID=4
ORDER BY i.DateCreated Desc

THe common key for the tables tbl_RegistrationInfo and tbl_Ideas is intRegID.
THe common key for the tables tbl_Ideas and tbl_Categories is intCategoryID.
And finally the user provides a value for the "idea" (i.intIdeaID=4).

i get a syntax error:

'syntax error in FROM clause'

I just dont see it. Can someone please help me? The small web app that I am writing will use this type of triple join often.

I did model this query from one I found online using the pubs sample db:


SELECT a.au_lname, a.au_fname, t.title

FROM authors a INNER JOIN titleauthor ta
ON a.au_id = ta.au_id JOIN titles t
ON ta.title_id = t.title_id
WHERE t.type = 'trad_cook'
ORDER BY t.title ASC

Thanks,
Luis