Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `ModeleVehicule`.`IdModel` , `LanguageDescriptions`.`Description`
- FROM `ModeleVehicule` , `LanguageDescriptions` , `TypeVehicule` , `ProduitVehicule` , `Produits`
- WHERE `ModeleVehicule`.`ManufacturerID` =16
- AND `ModeleVehicule`.`CodeDesignation` = `LanguageDescriptions`.`CodeDesignation`
- AND `ModeleVehicule`.`IdModel` = `TypeVehicule`.`VehicleModelId`
- AND `ProduitVehicule`.`IdVehicle` = `TypeVehicule`.`IdVehicle`
- AND `Produits`.`CategorieId` =13
- AND `Produits`.`ProduitId` = `ProduitVehicule`.`ProduitId`
- GROUP BY `ModeleVehicule`.`IdModel`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement