Left Join with Inner Join not supported?

[Mark]

I have three tables in a staff training database that I want to link
into a query but each time I think I have the right SQL statement
Access gives me a 'join not supported' message.

In simple terms the tables are;
COURSE_INFORMATION
CourseID
CourseType
CourseName

DATE_INFORMATION
DateID
CourseID
StartDate

SCHEDULE
ScheduleID
CourseType
CompletByDate
CourseID

Course_Information has a one to many relationship with
Date_Information as each course has one or more start dates.

The Schedule table holds a training plan in which the administrator
schedules the type of courses required for a member of staff and the
date they are to be completed by. The administrator then later
allocates specific courses to the schedule. Consequently some records
in the schedule table do not have course IDs.

I want to create a list that shows for a selected member of staff the
required course types, the date they should be completed by and the
names and dates of any courses already allocated.

I can succesfully link the Schedule table to the Course_Information
table using a left join which gives me a query showing all the course
types, completion dates and if allocated, the course name, but the
various ways I have tried to link the Date_Information table are
either rejected by access or only return records that all contain a
course ID.

Can anyone assist me with a solution here, It seems a simple enough
thing to do, I must be missing something?

Many thanks

Mark

 

[John Vinson]

It seems a simple enough
thing to do, I must be missing something?

Probably some parentheses. Access is very persnickety about them,
especially in Join clauses. Could you post your SQL (or at least the
join clause from it)? Or, try building the query in the query grid to
see how Access (deals with (its) excessive ((and redundant))
parenthetical nesting).

 

[Mark]

I have found the answer to the above problem.

Sorry to have troubled you.

Mark