1 2 3
| SELECT [Local].[Local_Adresse], [Local].[Local_Type], SUM([Local].[Local_Dimensions]*0.09290304) AS [Local_Dimensions], SUM([Local].[Local_Prix_ParUnite]*10.763910) AS [Local_Prix_ParUnite], [Local].[Local_Prix_Total], [Local].[Local_Responsables], [Entreprise].[Entreprise_Nom] FROM [dbo].[Local]
LEFT OUTER JOIN [dbo].[Entreprise] ON [Local].[Local_Entreprise_Id] = [Entreprise].[Entreprise_Id]
GROUP BY ([Local].[Local_Adresse], [Local].[Local_Type], [Local].[Local_Prix_Total], [Local].[Local_Responsables], [Entreprise].[Entreprise_Nom]) |
Partager