== Composicion ==
:[[VISTA:visreppres]]
:[[TABLA:clientes]]

== Estructura ==
<pre>
</pre>
== SQL ==
<pre>
CREATE VIEW `visrprescmp` AS 
SELECT 
	`visreppres`.`VidQuoteID` AS `VidQuoteID`,
	`visreppres`.`VidQuoteObra` AS `VidQuoteObra`,
	`visreppres`.`VidQuoteCliente` AS `VidQuoteCliente`,
	`visreppres`.`VidQuoteFecha` AS `VidQuoteFecha`,
	`visreppres`.`VidQuoteItem` AS `VidQuoteItem`,
	`visreppres`.`VidQuoteProdCantidad` AS `VidQuoteProdCantidad`,
	`visreppres`.`VidQuoteProdID` AS `VidQuoteProdID`,
	`visreppres`.`VidQuoteDetalle` AS `VidQuoteDetalle`,
	`visreppres`.`VidQuotePrecioS` AS `VidQuotePrecioS`,
	`clientes`.`RazonSocial` AS `RazonSocial`,
	`clientes`.`Direccion` AS `Direccion`,
	`clientes`.`Localidad` AS `Localidad`,
	`clientes`.`Provincia` AS `Provincia`
FROM (`clientes` JOIN `visreppres`) 
WHERE 	((`clientes`.`ClienteID` = `visreppres`.`VidQuoteCliente`)
			   AND `visreppres`.`VidQuoteID` IN 
			(SELECT `reppresqry`.`VidQuoteID` 
 			 FROM `reppresqry`))
 ORDER BY 	`visreppres`.`VidQuoteID`,
				`visreppres`.`VidQuoteObra`,
				`visreppres`.`VidQuoteCliente`,
				`visreppres`.`VidQuoteItem
</pre>
== Bitácora ==
== Uso ==
[[REPORT:PresupuestosDirecto]]

== URL ==
[[FZG.Vista.visprescmp.sql]]