Why does this query NOT produce results?

I wrote and executed this query:

Code:
select poitem.partnum, poitem.description, poitem.qtyfulfilled
from poitem
inner […]

Original post by aabuhl