So I'm having an issue with a query. My code is as follows
The problem comes in where I include the second inner join. The query works as it should when it is only:Code:SELECT TaskName FROM (BMS_Task INNER JOIN BMS_Occurrence ON BMS_Task.TaskID = BMS_Occurrence.TaskID) INNER JOIN BMS_Occurrence ON BMS_Occurrence.Day = date();
Any help would be appreciated. Thanks!Code:SELECT TaskName FROM (BMS_Task INNER JOIN BMS_Occurrence ON BMS_Task.TaskID = BMS_Occurrence.TaskID)