>>As Fabio pointed out, if BlogPk is a unique identifier in the blog_entries table, then this select doesn't make any sense
>>select blogpk,Max(entered) as entered FROM blog_entries GROUP BY blogpk
>>
>>Sorry if I stir you into wrong direction.
>
>No it isn't a unique identifier I think, for each blog_entry (PK) there belongs an owner(BlogPK), so you can have multiple blogpk. The results are as expected :).
Then it's fine <g> In our case we always use FK prefix for foreign keys, so PK at the end looked a little bit confusing for me. But if this BlogPK field is really an FK, then everything is fine.
If it's not broken, fix it until it is.
My Blog