[firebase-br] Selecionando mais que uma tabela

[Forrest®]

n4ndoprado wrote:

> "SELECT FIRST 20 SKIP 10 MOV_FOR, MOV_QUANT, MOV_DESPRO,
>             MOV_LOTE, MOV_DATA, MOV_VALID, MOV_DOCTO, MOV_PROD FROM
> sav_mov WHERE             (MOV_VALID >= 'data1' AND MOV_VALID <=
> 'data2') ORDER BY ASC";
---

Se entendi bem o que você quer, tente fazer assim


SELECT FIRST 20 SKIP 10 SM.MOV_FOR, SF.FOR_DES, SM.MOV_QUANT, 
       SM.MOV_DESPRO, SM.MOV_LOTE, SM.MOV_DATA, SM.MOV_VALID,   
       SM.MOV_DOCTO, SM.MOV_PROD 

FROM SAV_MOV SM LEFT OUTER JOIN SAV_FOR SF ON (SM.MOV_FOR = SF.FOR_COD) 

WHERE (SM.MOV_VALID BETWEEN 'data1' AND 'data2') 

ORDER BY ASC

Veja se assim funciona, mas fiz de cabeça.

T++++++++++++++

--