Display referenced node field in view
Shouldn't be too hard with a Views Relationship.

As you've mentioned, your View should show content (nodes). Here are the rough settings, as I see it:


Filters: Published or Admin; Content Type: Diary
Display: Fields
Relationships: Content-food nodereference field
Fields: Food (no reference...from the diary content type); calories (from the referenced food field)


That should about do it. I usually have to tweak Views relationships a bit to get them to work perfectly, so it's a bit tough for me to get it exactly right without seeing your content.

Best,
Scott