sql RETRIEVING DATA FROM TWO TABLES

[Guest]

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 here:
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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

As part of the Query Wizard, one can filter the data to reduce the number of
rows returned.........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thinking of it, may next code have to work? (in Sql syntax) and the trouble
is msQuery is limited ?

SELECT COCLI, DATA, CODIART, DESCRIPCIO, PREUNET, PORTS, QUANT
FROM (SELECT 1 AS LIN07.CODIART UNION ALL SELECT 2 AS SELECT LIN06.CODIART )
WHERE CODIART Like '50404%'


Thanks for the help.
ramonvi