Double Join Problem

[willard]

Im rubbish at doing these joins.. this one is really fathoming me.
3 Tables (brackets are the unique keys Im trying to join).

USER(id_user_pk), TODOLIST(id_user,id_patient), PATIENT(id_patient_pk)

I thought this would work..Its not failing but it's not bringing
anything back which is kind of sad :(

SELECT *
FROM
TODOLIST as td
INNER
JOIN
USER user
ON user.id_user_pk=td.id_user
INNER
JOIN
patient pt
ON pt.id_patient_pk=td.id_patient

Any tips??!
Thanks :)

Will

[toby]

If this isn't returning any results, then there are no related records
(or no records at all). Try manually inspecting your data to see if it
is what you think it is.