使用JOIN查询从数据库中选择上一个时间戳

I have a query that selects groups and group postings. In the postings table there is a timestamp collumn, and a group_id. I need to select the greatest timestamp in the postings table, associated with the group id.I have a query that selects groups and group po