Hello!
I get a problem which I remember having now and then, only I cannot remember how I dealt with it previously.
Code:
select name, max(post_time) as maxtime
from `members`, `posts`
where id = author_id
group by name
Like that, it shows the time of the latest post for each member - who has ever posted something; but it ignores the members who don't have posts to choose the youngest from, and skips them.
Is there a way to make it show also the names of the members who doesn't have a post at all - then on column `maxtime` it could show NULL, for example.
Thanks!
Janis
Show ALL records from one table
