1 2
| SELECT DISTINCT culture.[id culture], [It treatment].[id treatment], [id vegetable].[vegetable name], [id category].[category name], [id pesticide].[pesticide name], [molecule irac].[name molecule], [id irac].[code irac], [id pesticide].[id pesticide], [It treatment].[id pesticide], [IT IRAC mol].[id pesticide], [IT IRAC mol].[id irac], [IT IRAC mol].[id molecule irac]
FROM culture INNER JOIN ([id irac] INNER JOIN ([molecule irac] INNER JOIN (((worker INNER JOIN (([id category] INNER JOIN [id pesticide] ON [id category].[Id category] = [id pesticide].[id category]) INNER JOIN ([id vegetable] INNER JOIN [It treatment] ON [id vegetable].[id vegetable] = [It treatment].[id vegetable]) ON [id pesticide].[id pesticide] = [It treatment].[id pesticide]) ON worker.[id worker] = [It treatment].[id worker]) INNER JOIN [it pesticide insect] ON ([id vegetable].[id vegetable] = [it pesticide insect].[id vegetable]) AND ([id pesticide].[id pesticide] = [it pesticide insect].[id pesticide])) INNER JOIN [IT IRAC mol] ON [id pesticide].[id pesticide] = [IT IRAC mol].[id pesticide]) ON [molecule irac].[id molecule irac] = [IT IRAC mol].[id molecule irac]) ON [id irac].[id irac] = [IT IRAC mol].[id irac]) ON ([id vegetable].[id vegetable] = culture.[id vegetable]) AND (culture.[id culture] = [It treatment].[id culture]); |
Partager