Não vai de um jeito, vai de outro.... rs
:cSQL := "SELECT D.*," + ;
" ( 100 + PERCENTUALA ) / 100 * PRECOBASE AS TABA," + ;
" ( 100 + PERCENTUALB ) / 100 * PRECOBASE AS TABB," + ;
" ( 100 + PERCENTUALC ) / 100 * PRECOBASE AS TABC," + ;
" ( 100 + PERCENTUALD ) / 100 * PRECOBASE AS TABD," + ;
" ( 100 + PERCENTUALE ) / 100 * PRECOBASE AS TABE," + ;
" ( 100 + PERCENTUALF ) / 100 * PRECOBASE AS TABF" + ;
" FROM (" + ;
" SELECT IDPRODUTO, IEPRODEP, IEVALCUS, IECUSCON, IEULTPRE, " + ;
" GREATEST( IEVALCUS, IECUSCON * X.MARGEM," + ;
" IEULTPRE * X.MARGEM ) AS PRECOBASE," + ;
" COALESCE( A.PERCA, B.PERCA, C.PERCA, 0 ) AS PERCENTUALA," + ;
" COALESCE( A.PERCB, B.PERCB, C.PERCB, 0 ) AS PERCENTUALB," + ;
" COALESCE( A.PERCC, B.PERCC, C.PERCC, 0 ) AS PERCENTUALC," + ;
" COALESCE( A.PERCD, B.PERCD, C.PERCD, 0 ) AS PERCENTUALD," + ;
" COALESCE( A.PERCE, B.PERCE, C.PERCE, 0 ) AS PERCENTUALE," + ;
" COALESCE( A.PERCF, B.PERCF, C.PERCF, 0 ) AS PERCENTUALF" + ;
" FROM JPITEM" + ;
" LEFT JOIN JPTABPRODEP ON IDPRODEP = IEPRODEP" + ;
" LEFT JOIN JPTABPROSEC ON IDPROSEC = IEPROSEC" + ;
" LEFT JOIN JPTABPROGRU ON IDPROGRU = IEPROGRU" + ;
" LEFT JOIN JPTABPERCENTUAL AS A ON A.PERCPRODUTO = IDPRODUTO" + ;
" LEFT JOIN JPTABPERCENTUAL AS B ON B.PERCPRODEP = IEPRODEP" + ;
" LEFT JOIN JPTABPERCENTUAL AS C ON C.PERCPRODEP = 0 AND C.PERCPRODUTO = 0" + ;
" JOIN ( SELECT IF( EXISTS ( SELECT DISTINCT PCPRODUTO FROM JPPRECO WHERE PCPRODUTO=" + ;
NumberSQL( nIdProduto ) + "), 1.03, 1.04 ) AS MARGEM ) AS X" + ;
" WHERE IDPRODUTO = " + NumberSQL( nIdProduto ) + " ) AS D"
Pra que complicar kkkkkkk