kevlray
Registered User.
- Local time
- Today, 10:18
- Joined
- Apr 5, 2010
- Messages
- 1,046
We have an Access (2007) DB with a MS-SQL (2008) back end. I was struggling in Access to get the results I wanted, so I switched over to MS-SQL and got a query to work. When I bring the query over to Access (Create, Query Design, SQL). When I try to execute it, I get a syntax error in From clause. Basically I am trying to list all the employees that have not attended the ' Performance Management and MOC Redesign' training. The aliased MTbl_Employee tables are just to bring other supervisors names in. I tried a sub-query as a table and Access did not like that either.
select distinct
Mtbl_Employees.[Employee#]
, Mtbl_Employees.EmployeeName as Supervisor
, AD.EmployeeName as ADEmpNm
, DM.EmployeeName as DMEmpNm
from MTbl_Employees
join MTbl_Positions on MTbl_Positions.[Pos#] = MTbl_Employees.[Pos#]
left join MTbl_Employees as AD on AD.[Pos#] = Mtbl_Positions.[ADPos#]
left join MTbl_Employees as DM on DM.[Pos#] = Mtbl_Positions.[DMPos#]
where
Mtbl_Employees.Sup = 1
and
Not exists (select [Employee#]
from Etbl_Training
where Training = 'Performance Management and MOC Redesign'
and MTbl_Employees.[Employee#] = ETbl_Training.[Employee#])
order by [Employee#]
Any suggestions would be appreciated.
select distinct
Mtbl_Employees.[Employee#]
, Mtbl_Employees.EmployeeName as Supervisor
, AD.EmployeeName as ADEmpNm
, DM.EmployeeName as DMEmpNm
from MTbl_Employees
join MTbl_Positions on MTbl_Positions.[Pos#] = MTbl_Employees.[Pos#]
left join MTbl_Employees as AD on AD.[Pos#] = Mtbl_Positions.[ADPos#]
left join MTbl_Employees as DM on DM.[Pos#] = Mtbl_Positions.[DMPos#]
where
Mtbl_Employees.Sup = 1
and
Not exists (select [Employee#]
from Etbl_Training
where Training = 'Performance Management and MOC Redesign'
and MTbl_Employees.[Employee#] = ETbl_Training.[Employee#])
order by [Employee#]
Any suggestions would be appreciated.