Moving sql to access

  • Thread starter Thread starter Jack
  • Start date Start date
J

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.
 
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.
Click to expand...
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 <--
 
Back
Top