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")