Thanks for your answer, Chuck.

I'm afraid doing so I would have lots of rows since for each row in one
query it adds the number of rows found in 2nd query.

Thanks anyway
ramonvi



"CLR" wrote:

I would try recording a macro while going through the Data Get External
Data Create new Query sequence, twice, once for each table..........that
should at least give you something you can edit...

Vaya con Dios,
Chuck, CABGx3



"ramonvi" wrote:

Hi,

I'm trying to retrieve data from two identical tables (different name and
data but same structure) into a Excel sheet.
I'm trying something like
"SELECT DISTINCT LIN07.COCLI, LIN07.DATA, LIN07.CODIART, LIN07.DESCRIPCIO,
LIN07.PREUNET, LIN07.PORTS, LIN07.QUANT
FROM `X:\Geseuro\FAC1`\LIN07.DBF LIN07
UNION
SELECT LIN06.COCLI, LIN06.DATA, LIN06.CODIART, LIN06.DESCRIPCIO,
LIN06.PREUNET, LIN06.PORTS, LIN06.QUANT FROM
`X:\Geseuro\FAC1`\LIN06.DBF LIN06
WHERE (LIN07.CODIART LIKE '50404%') OR (LIN06.CODIART LIKE '50404%')"

It gives me an error : "too few parameters. 1 was expected"

Two questions comes he
1.- Is this a way to do this (retrieving data from 2 tables)?
2.- What's wrong in my sentence?

Thanks for your help.
ramonvi