SQL - get the article title with the last comment date
- by stacker
I have articles table, article_comments.
I want to get the value: last_modified_all of article. I need this value to be the great date of this two:
the last_modified field of articles table.
the last comment of article_comments last_modified column.
Can someone help me? the structure is very simple, and you can guess is without problem.