ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple queries using *.dqy files (https://www.excelbanter.com/excel-programming/275616-multiple-queries-using-%2A-dqy-files.html)

Bart E

Multiple queries using *.dqy files
 
Hi all,

Is it possible when you saved a MS query to an *.dqy
file, that you use this same query in an other query and
do some joining ?
I.e.

SELECT Color_Table.Color_Field, Pattern_Table.Pattern_Field
FROM {oj c:\path_saved_dqy_query table LEFT OUTER JOIN
table_name ON Color_Table.Join_Field =
Pattern_Table.Join_Field}

Thanks in advance.

Regards,
Bart



All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com