This error has been reported in a number of previous occasions. However in my case non of the suggested solutions appears to work
--==================================================
CREATE VIEW dbo.vAllLesions
AS SELECT
dbo.Patients.idP, dbo.Patients.Surname, dbo.Patients.GName, dbo.Patients.Sex,
dbo.Patients.DoB, dbo.Lesions.idL, dbo.Lesions.OriginalIdBase,
dbo.Lesions.OriginalIdL,
dbo.Lesions.Notes,
dbo.Lesions.idBatch,
dbo.UserLesionFlags.value As FlagValue
FROM********
dbo.Lesions INNER JOIN
****************dbo.Patients ON dbo.Lesions.idP = dbo.Patients.idP LEFT OUTER JOIN
****************dbo.UserLesionFlags ON dbo.Lesions.idL = dbo.UserLesionFlags.idL
WHERE**** (dbo.Patients.Exported = 0) AND (dbo.Patients.DeletedDay IS NULL) AND (dbo.Lesions.DeletedDay IS NULL)
GO
--
================================================
Server: Msg 170, Level 15, State 1, Procedure vAllLesions, Line 10
Line 10: Incorrect syntax near '*'.
Acoording to the error report there is a proplem with inner join but just what is the problem.
Regards
Joe