Moving sql to access

[Jack]

Hi,
I have a view in sql server as follows:
SELECT A.ApprovalID, A.CaseID,
L.[Name],
Q.[Name],
P.[Name],
D.[Name]
FROM dbo.Approval A
JOIN dbo.Employee L
ON A.TeamLeaderID = L.EmployeeID
JOIN dbo.Employee Q
ON A.QualityManagerID = Q.EmployeeID
JOIN dbo.Employee P
ON A.ProductionManagerID = P.EmployeeID
JOIN dbo.Employee D
ON A.DirectorID = D.EmployeeID;

I need to create a query in Access bases on this view. I tried pasting the
code in Access sql but it does not work. What changes are necessary to have
this view moved to Access query. I appreciate any help. Thanks.

 

[Stefan Hoffmann]

hi Jack,

I need to create a query in Access bases on this view. I tried pasting the
code in Access sql but it does not work. What changes are necessary to have
this view moved to Access query. I appreciate any help. Thanks.

Just link the view into your .mdb.

Otherwise use the query designer to recreate the view. The basic problem
is that Jet SQL requires parentheses for ordering the joined tables.


mfG
--> stefan <--