Ok I think you want to eliminate users with date > 14 mar if they are also in < 14. You have to do
select * from table as a
where a.date > 14 mar
and not exists (select * from table as b join a on a.user=b.user
where date < 14 mar)
Results 1 to 9 of 9
Thread: Finding difference with JoinThreaded View
|
|
|