Have used inner join before but trying to get my head round columns with different names.
Trying to call the following information in a query but can’t seem to get it right when using the inner join to cross reference tables.
SELECT * FROM booked_open INNER JOIN courses ON booked_open.cidx = courses.idx WHERE booked_open.didx=$course;
I need all information called from booked_open ($var->name, $var->tel, etc)
The booked_open.cidx reference number matches the courses.idx number and just need to pull a single title name from the courses table into the booked_open query.
I am trying to get courses.title into the query so i can access it as $var->title
I have used inner join before but the column names between these two tables are different so I am struggling to understand the link and how you use inner join in this instance.
Many thanks