The title for this question pretty much sums up what I'm asking.

I've got a list of taxonomy terms, and I'm using a view to display the latest post to each one. I'd like to also display a custom field set up in CCK just under this.

Currently, I'm just using "date updated" of the taxonomy term itself which was easy to set up in views. I'd like to drill a little deeper and get the custom "event date" field I've added to the content type last posted to the taxonomy term I'm "viewing".

I've got a feeling I'm going to have to write my own database query for this.

If (I can avoid that){ How do I set up such a view? } Else{ What's the best practice for including lower level database queries alongside views? }