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.