how can handles this query

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

how can handles this query

hagersaleh
how can handles this query
SELECT a.id, (SELECT MAX(created) FROM posts WHERE author_id = a.id) AS latest_post FROM authors a