Erro na sintaxe do SQL?

Question

Pessoal, alguem pode me dizer qual o motivo do erro na syntaxe desta SQL?Olhem o erro que acusa![b:8aa86d6a2c]Dynamic SQL ErrorSQL code error = -104Token unknown -line 4, column 14[.[/b:8aa86d6a2c]Olh...

Adriano_servitec · Answer

Olah pessoal, ja descubri o erroO correto eh assim[code:1:d729c5425d]SELECT C.GRAUD AS GRAU, C.valor_A, C.valor_b, (C.valor_A - C.valor_b) AS SALDO FROM (SELECT A1.GRAUD, A1.valor_A, B1.GRAUC, B1.valor_b FROM (SELECT TGRAU1_D.GRAUD, sum(TGRAU1_D.valor) AS valor_A FROM TGRAU1_D GROUP BY TGRAU1_D.GRAUD) AS A1, (SELECT TGRAU1_C.GRAUC, SUM(TGRAU1_C.valor) AS valor_b FROM TGRAU1_C GROUP BY TGRAU1_C.GRAUC ) AS B1) AS C WHERE C.GRAUD=C.GRAUC [/code:1:d729c5425d] :oops:...

Adriano_servitec · Answer

Bom o select acima inclui resultado de duas tabelas, mais agora me veio a necessidade de incluir 4 tabelas numa soh grid

as duas primeiras estao como o post acima, ai fiz mais outra com da mesma maneira

SELECT C.GRAU2D AS GRAU, C.valor_A, C.valor_b, 
(C.valor_A - C.valor_b) AS SALDO 
FROM (SELECT A1.GRAU2D, A1.valor_A, B1.GRAU2C, B1.valor_b 
FROM (SELECT TGRAU2_D.GRAU2D, sum(TGRAU2_D.valor) AS 
valor_A FROM TGRAU2_D GROUP BY TGRAU2_D.GRAU2D) AS A1, 
(SELECT TGRAU2_C.GRAU2C, SUM(TGRAU2_C.valor) AS valor_b FROM TGRAU2_C GROUP BY TGRAU2_C.GRAU2C ) AS B1) AS C 
WHERE C.GRAU2D=C.GRAU2C

soh mudando o nome dos campos

Bom a pergunta eh, como unir esses select num soh para mostrar o resultado num dbgrid?

Tentei assim mais ta longe de ser um select

SELECT C.GRAUD AS GRAU, C.valor_A, C.valor_b, 
(C.valor_A - C.valor_b) AS SALDO 

FROM (SELECT A1.GRAUD, A1.valor_A, B1.GRAUC, B1.valor_b, A1.GRAU2D, A1.valor_A, B1.GRAU2C, B1.valor_b
 
FROM (SELECT TGRAU1_D.GRAUD, sum(TGRAU1_D.valor) AS 
valor_A FROM TGRAU1_D,TGRAU2_D.GRAU2D, sum(TGRAU2_D.valor) AS 
valor_A FROM TGRAU2_D GROUP BY TGRAU1_D.GRAUD and TGRAU2_D.GRAU2D) AS A1, 

(SELECT TGRAU1_C.GRAUC, SUM(TGRAU1_C.valor) AS valor_b FROM TGRAU1_C, TGRAU2_C.GRAU2C, SUM(TGRAU2_C.valor) AS valor_b FROM TGRAU2_C  GROUP BY TGRAU1_C.GRAUC and TGRAU2_C.GRAU2C ) AS B1) AS C

WHERE C.GRAUD=C.GRAUC and C.GRAU2D=C.GRAU2C

Mais acho que a ideia come�a por ai.

Agrade�o a ajuda de todos
Adriano

[b:a78206985b]Estou usando firebird 2.0[/b:a78206985b]

Adriano_servitec · Answer

Topo...

Adriano_servitec · Answer

Ja consegui[code:1:60cf884ccc]SELECT C.GRAUD AS GRAU, C.valor_A, C.valor_b,(C.valor_A - C.valor_b) AS SALDOFROM (SELECT A1.GRAUD, A1.valor_A, B1.GRAUC, B1.valor_bFROM (SELECT TGRAU1_D.GRAUD, sum(TGRAU1_D.valor) ASvalor_A FROM TGRAU1_D GROUP BY TGRAU1_D.GRAUD) AS A1,(SELECT TGRAU1_C.GRAUC, SUM(TGRAU1_C.valor) AS valor_bFROM TGRAU1_C GROUP BY TGRAU1_C.GRAUC ) AS B1) AS CWHERE C.GRAUD=C.GRAUCunionSELECT C.GRAU2D AS GRAU, C.valor_A, C.valor_b,(C.valor_A - C.valor_b) AS SALDOFROM (SELECT A1.GRAU2D, A1.valor_A, B1.GRAU2C, B1.valor_bFROM (SELECT TGRAU2_D.GRAU2D, sum(TGRAU2_D.valor) ASvalor_A FROM TGRAU2_D GROUP BY TGRAU2_D.GRAU2D) AS A1,(SELECT TGRAU2_C.GRAU2C, SUM(TGRAU2_C.valor) AS valor_bFROM TGRAU2_C GROUP BY TGRAU2_C.GRAU2C ) AS B1) AS CWHERE C.GRAU2D=C.GRAU2CunionSELECT C.GRAU3D AS GRAU, C.valor_A, C.valor_b,(C.valor_A - C.valor_b) AS SALDOFROM (SELECT A1.GRAU3D, A1.valor_A, B1.GRAU3C, B1.valor_bFROM (SELECT TGRAUSUPD.GRAU3D, sum(TGRAUSUPD.valor) ASvalor_A FROM TGRAUSUPD GROUP BY TGRAUSUPD.GRAU3D) AS A1,(SELECT TGRAUSUPC.GRAU3C, SUM(TGRAUSUPC.valor) AS valor_bFROM TGRAUSUPC GROUP BY TGRAUSUPC.GRAU3C) AS B1) AS CWHERE C.GRAU3D=C.GRAU3C[/code:1:60cf884ccc]Valeu...

F�rum Erro na sintaxe do SQL? #58162