With Join and without Join

[#1]

Hi everyone;

I have a problem with the next query;

CxC:

LOAD
   factura,
   cod_cliente,
   tipo_factura,
   cia_contable,
   cxc_fiscal_year,
   cxc_fiscal_month
FROM Dimensiones\CXC.qvd(qvd);

saldos:
LOAD factura,
     cod_cliente,
     tipo_factura,    
     cia_contable,
     cxc_fiscal_year,
     cxc_fiscal_month,
     [date(action_date,'MM-DD-YYYY')],
     saldohome_mxp,
     saldocurr_mxp
FROM Dimensiones\saldos.qvd(qvd);

this query do match with the same name columns and

The resul of this query show me x's number of  rows for example 10000 rows

BUT i need the result of this query in one table to insert in a qvd the problem is

when i did do this;

CxC:

LOAD
   factura,
   cod_cliente,
   tipo_factura,
   cia_contable,
   cxc_fiscal_year,
   cxc_fiscal_month
FROM Dimensiones\CXC.qvd(qvd);

Left Join

LOAD factura,
     cod_cliente,
     tipo_factura,    
     cia_contable,
     cxc_fiscal_year,
     cxc_fiscal_month,
     [date(action_date,'MM-DD-YYYY')],
     saldohome_mxp,
     saldocurr_mxp
FROM Dimensiones\saldos.qvd(qvd);

The result show me now LESS rows for example 9000 instead of 10000 rows beacause  added the word Left Join and this number of rows is incorrect.

Can you help me please???

[swuehl]

How do you get your count of rows?

Are you doing a count of a field (which one? Distinct or not?) or are you looking at the number of CxC records in table viewer (CTRL-T)?