Replacing ID key with column Name
I have looked at the help on this forum concerning the INNER JOIN but I am still a little confused how to execute this MYSQL statement manually.
I have table1 (courses) and reference table2 (course_category).
I have a foriegn key in courses called subject_cat_id. This is the primary key in refernce table 2 (course_category).
After using dataassist wizard, my insert record behaviour, sql statement on my results page looks like this:
SELECT course_id, subject_cat_id, course_title, course_code, course_price
I have tried to do an inner join;
SELECT courses.course_id, courses.subject_cat_id, courses.course_title, courses.course_code, courses.course_price, course_category.course_category_title,
INNER JOIN course_category
ON courses.subject_cat_id = course_category.course_cat_id
I keep coming up with mysql errors. I really need to replace subject_cat_id with subject_category_title, from (table2) course_category on my rsults page.