Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql RETRIEVING DATA FROM TWO TABLES
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql RETRIEVING DATA FROM TWO TABLES
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql RETRIEVING DATA FROM TWO TABLES
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql RETRIEVING DATA FROM TWO TABLES
As part of the Query Wizard, one can filter the data to reduce the number of
rows returned......... Vaya con Dios, Chuck, CABGx3 "ramonvi" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql RETRIEVING DATA FROM TWO TABLES
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 "ramonvi" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieving info from multiple tables | Excel Discussion (Misc queries) | |||
retrieving data | Excel Worksheet Functions | |||
Retrieving Data from Excel Pivot tables into Datatable | Excel Programming | |||
Retrieving Web Data | Excel Programming | |||
Retrieving data | Excel Programming |