SQL to ACCESS

  • Thread starter Thread starter PaulM
  • Start date Start date
P

PaulM

I have a sql call I use to query SQL server. I works fine under SQL server
but not with Access 2000.

SELECT TOP 100 PERCENT gm.MenuID, gm.Caption, gm.ParentMenu,
gm.AssociateMenuID, gm.VBClassItem, gm.ParamName, gm.IsFolder,
gm.IsDynamicItem, cl.TagName
FROM GUSMenu.vw_GUSMenu gm LEFT OUTER JOIN
GUSMenu.vw_ComplexLoop cl ON cl.MenuItemID = gm.MenuItemID
AND cl.GroupID =
(SELECT TOP 1 cl.GroupID
FROM GUSMenu.ComplexLoop cl INNER JOIN
GUSMenu.Depts d ON d.DeptID = cl.DeptID
WHERE d.DeptName = 'DH' AND cl.TagName = '1t1234') AND
cl.DeptName = 'DH'
WHERE (gm.MenuType = 'REG') AND (gm.DeptName = 'DH')
ORDER BY gm.MenuID, cl.Priority

Looks like it stops at the first AND after LEFT OUTER JOIN. It says
something about join expression not supported. Please help. Thanks
 
Back
Top