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