==== FZG.Vista.vislineabs.sql ====
<small><pre>
SELECT
    vidquoten2.VidQuoteID AS VidQuoteID,
    vidquoten1.VidQuoteObra AS VidQuoteObra,
    vidquoten1.VidQuoteCliente AS VidQuoteCliente,
    vidquoten1.VidQuoteFecha AS VidQuoteFecha,
    vidquoten1.VidQuoteEstado AS VidQuoteEstado,
    vidquoten2.VidQuoteItem AS VidQuoteItem,
    vidquoten2.VidQuoteProdCantidad AS VidQuoteProdCantidad,
    vidquoten2.VidQuoteProdID AS VidQuoteProdID,
    IF(vidquoten2.VidQuoteAncho > 0
        ,IF(vidquoten2.VidQuoteAlto > 0
        ,CONCAT(productos.Descripcion," -Dimensión(mm): ",LPAD(CAST(vidquoten2.VidQuoteAncho AS CHAR),4,"0000"),"x",LPAD(CAST(vidquoten2.VidQuoteAlto AS CHAR),4,"0000"),"-")
        ,CONCAT(productos.Descripcion," -Largo(mm): ",LPAD(CAST(vidquoten2.VidQuoteAncho AS CHAR),4,"0000"),"mm-")
        )
    ,productos.Descripcion
    ) AS Descripcion,
    vissubxitem.VidQuotePrecioS AS VidQuotePrecioS
FROM
    (((vidquoten1
    JOIN vidquoten2)
    JOIN productos)
    JOIN vissubxitem)
WHERE
    ((vidquoten1.VidQuoteID = vidquoten2.VidQuoteID) and
    (productos.ProductoID = vidquoten2.VidQuoteProdID) and
    (vissubxitem.VidQuoteID = vidquoten2.VidQuoteID) and
    (vissubxitem.VidQuoteItem = vidquoten2.VidQuoteItem))
</pre></small>