Help with MySql Join

PHP
1

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, coaches.phone, coaches.email, 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?

D.

2 
WHERE coaches.age_group = 8

or

WHERE training.age_group = 8
3

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