table joins

danielhalawi

Hey,

I've had a little help with this query before, however I can't seem to get the joins to work... keep gettin error 1066 when I run the sql.

Basically I want to join

courses_dates.id = courses_attendance.courseid
courses_dates.courseid = courses.id
courses_attendance.staffid = staff.id
courses_attendance.location = stores.id

Is it possible to do more than one join at a time?

sneakyimp

multiple joins is definitely possible
what does your sql look like?

danielhalawi

SELECT 
courses.id, 
courses.coursename, 
courses.coursedes, 
courses.coursesize, 
courses_dates.id, 
courses_dates.courseid, 
courses_dates.coursedate, 
courses_dates.location, 
staff.id, 
staff.firstname, 
staff.lastname, 
staff.startdate, 
store.id, 
store.storenumber, 
store.storename, 
courses_attendance.id, 
courses_attendance.staffid, 
courses_attendance.courseid 
FROM courses, courses_attendance, courses_dates, staff, store

Thats bascially pulling out all the information from all tables.
All I wanna end up with is
courses.coursename
courses_dates.coursedate
staff.firstname staff.lastname
store.storename

Any help, much appriciated

sneakyimp

I'm guessing that query doesn't get what you want but returns instead a huge mess of non-related values in a record set that is way too large.

But it shouldn't return a 1066 error as far as i can tell. Have you tried the JOIN query? You should be able to join quite a few tables. I think the limit might be about 12 for mysql 3.23.