<small><pre>
CREATE VIEW `precioscmpl` AS
SELECT 
	`precios`.`ProductoID` AS ProductoID, 
	`productos`.`Descripcion` AS ProductoDSC, 
	`productos`.`CategoriaID` AS CategoriaID, 
	`productos`.`ProveedorID` AS ProveedorID, 
	`precios`.`PrecioProd00` AS PrecioProd00, 
	`productos`.`CoefP00P01` AS CoefP00P01, 
	`precios`.`PrecioProd01` AS PrecioProd01, 
	`productos`.`CoefP00P02` AS CoefP00P02, 
	`precios`.`PrecioProd02` AS PrecioProd02, 
	`productos`.`CoefP00P03` AS CoefP00P03, 
	`precios`.`PrecioProd03` AS PrecioProd03
FROM	`fzggestion`.`productos` AS `productos`, 
		`fzggestion`.`precios` AS `precios` 
WHERE `productos`.`ProductoID` = `precios`.`ProductoID`
ORDER BY `precios`.`ProductoID`
</pre></small>