Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.67K
1 Posted Topic
How about something like this instead; perhaps it is a little cleaner - you don't have to filter out so many null rows [code=mysql] SELECT DISTINCT data.id, other.otherinfo, other.datefield FROM data LEFT JOIN ( SELECT data_id, max(datefield) latest_date FROM other GROUP BY data_id ) rep on data.id=rep.data_id LEFT JOIN other …
The End.