Hi hopefully there's an easy fix to this - I think there will be I have three tables A, B, C
I am running a select statement from table B.
I left join to table A on a common variable (taskgroup_id) all good
I left join to C on a common variable but because this variable is in all 3 tables (i thihk this is why) I am getting an error "Column 'division_id' in from clause is ambiguous "
IFNULL(A.taskgroup, '[None Assigned]'),
LEFT JOIN A USING(taskgroup_id)
LEFT JOIN C USING(division_id)
WHERE task_id = etc