Helllo,
i try to execute this query but i have an error at the ON clause :
SELECT [itm].[OccurrenceId], [itm].[ContainerId], [itm].[StoreId]
FROM [businessStore].[ItemAtStore] AS [itm]
INNER JOIN [businessStore].[BoxItem] AS [itm.BoxItem] ON [itm].[ItemBoxId] = [itm.BoxItem].[Id]
INNER JOIN [businessStore].[ObjectLastDetail] AS [ob] ON [itm].[ItemBoxId] = [ob].[ObjectId]
INNER JOIN [businessStoreOut].[OutRef] ON ob.OutRefId = OutRef.Id
INNER JOIN [businessStore].[ItemBoxType] AS [itm.BoxItem.ItemBoxType] ON [itm.BoxItem].[ItemBoxTypeId] = [itm.BoxItem.ItemBoxType].[Id]
LEFT JOIN ([businessStore].[OccurenceQuality] AS [ea] ON [ob.OccurrenceId] = [ea].[OccurrenceId]) -- this on give me an error in Sql "Incorrect syntax near ON"
INNER JOIN [businessStore].[Quality] AS [at] ON [at].[Id] = [ea].[QualityId]) ON ([ob].[OccurrenceId] = [ea].[OccurrenceId]) AND ([at].[Code] = 'NEW')
WHERE [itm].[ContainerId] = @ContainerId
Can someone help me?
Thanks