Hi Guys, feel quite stupid with this one, been staring at it for ages.
What to combine three tables with the left join sql. keep getting the syntax error in Join operation.
SELECT SubmittedTeam FROM (NETT LEFT JOIN NETT ON NETT.SubmittedTeam = Team.Team) LEFT JOIN tempDate ON NETT.Date = tempDate.date WHERE tempDate.date is NULL AND Team.Team is NULL;
Thank you so much for looking at this.