I have a view in SQL serever 2000 that I was trying to link to access. However every time I linked it, I could not open the table.
So I need to rewrite this view in access. I am not an access programmer, so my SQL seems to be off in this, even though it runs fine in SQL Server.
SELECT dbo.Project.PROIDNO, dbo.Project.PROOFFICE, dbo.Project.PRODEPT, Employee_1.EMPSNAME AS Pic, dbo.Employee.EMPSNAME AS PM,
dbo.Project.PROLNAME
FROM dbo.Project LEFT OUTER JOIN
dbo.Employee ON RIGHT(dbo.Project.PROPRIN, LEN(LTRIM(RTRIM(dbo.Project.PROPRIN))) - 1) = dbo.Employee.EMPIDNO LEFT OUTER JOIN
dbo.Employee Employee_1 ON RIGHT(dbo.Project.PROPM, LEN(LTRIM(RTRIM(dbo.Project.PROPM))) - 1) = Employee_1.EMPIDNO
So I need to rewrite this view in access. I am not an access programmer, so my SQL seems to be off in this, even though it runs fine in SQL Server.
SELECT dbo.Project.PROIDNO, dbo.Project.PROOFFICE, dbo.Project.PRODEPT, Employee_1.EMPSNAME AS Pic, dbo.Employee.EMPSNAME AS PM,
dbo.Project.PROLNAME
FROM dbo.Project LEFT OUTER JOIN
dbo.Employee ON RIGHT(dbo.Project.PROPRIN, LEN(LTRIM(RTRIM(dbo.Project.PROPRIN))) - 1) = dbo.Employee.EMPIDNO LEFT OUTER JOIN
dbo.Employee Employee_1 ON RIGHT(dbo.Project.PROPM, LEN(LTRIM(RTRIM(dbo.Project.PROPM))) - 1) = Employee_1.EMPIDNO