Active Query Builder support area

Syntax SQL server is not running with two "ON" in the view

Avatar
  • updated
  • Completed

Hello I use sql server and management, if I write my view like this there are an error

SELECT dbo.[tbl intervention ot rapport].arretnecessaireon, dbo.[tbl unité fonctionnelle ensemble].code AS equipement
FROM dbo.[tbl unité fonctionnelle ensemble] RIGHT OUTER JOIN
dbo.[tbl intervention ot rapport] INNER JOIN
dbo.[tbl configuration ot dt] ON dbo.[tbl intervention ot rapport].[num origine défaillance] = dbo.[tbl configuration ot dt].[num origine défaillance] ON
dbo.[tbl unité fonctionnelle ensemble].[num unité fonctionnelle ensemble] = dbo.[tbl intervention ot rapport].[num unité fonctionnelle ensemble sel]

if I write this it s it s good

SELECT dbo.[tbl intervention ot rapport].arretnecessaireon, dbo.[tbl unité fonctionnelle ensemble].code AS equipement
FROM dbo.[tbl intervention ot rapport] INNER JOIN
dbo.[tbl configuration ot dt] ON dbo.[tbl intervention ot rapport].[num origine défaillance] = dbo.[tbl configuration ot dt].[num origine défaillance] LEFT OUTER JOIN
dbo.[tbl unité fonctionnelle ensemble] ON dbo.[tbl intervention ot rapport].[num unité fonctionnelle ensemble] = dbo.[tbl unité fonctionnelle ensemble].[num unité fonctionnelle ensemble]


The reason seem come from the "ON" in view is directly after an other "ON" is there a solution to have the good translation

Thank you




Avatar
contact

thank you

Avatar
Andrey Zavyalov, PM

Hello,

The bug has been fixed in the new version 3.2.0.1029. Please confirm that it's fixed on your side.

Avatar
contact

Thank you it s perfect