SELECT distinct email,lastupdated FROM
FantasyTeams A Left JOIN ‘Users` B ON (A.handle = B.handle)
Where lastupdated <‘2021-08-31′ AND lastupdated>’2021-04-31’ AND email is not null ORDER BY lastupdated DESC
I have two tables, Fantasy Teams and Users, which I’m joining using left join, but the emails seem to duplicate. What’s the solution?