Help with MySql Join

Hi Folks,

I’m struggling with a MySql join.
I have two tables coaches and training. Here’s what I have

SELECT coaches.first_name, coaches.surname,,, training.day_time
FROM coaches INNER JOIN training ON coaches.age_group = training.age_group

WHich works nicely but what I need is the above with “WHERE age_group =8” or something that does the job of only pulling out the info from both tables that has an age_group of 8.

Everything I try returns a ‘clause is ambiguous’ error.

Any ideas?


WHERE coaches.age_group = 8


WHERE training.age_group = 8

Perfect thanks.
Why didn’t I think of that. (Doh!)