You dont need a join... a simple subquery should work fine.
select * from <table> a
where date > "14-Mar-08"
and not exists ( select 1 from <table> b where a.user=b.user and date <= "14-Mar-08")
Results 1 to 9 of 9
Thread: Finding difference with JoinThreaded View
|
|
|