Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used QV for a few weeks and tried to find a way to upload multiple SQL queries from the same database. What I want to do is populate QV with five different queries in one script and end up with five different tables that are not joined in any way.
How can I do this in one script?
hi,
you have many options:
1) use concatenate
2) use Join
3) in the script (select) change the key fields to the same name in all the tables.
i hope that will help you.
BR.
Ariel
LOAD yourtables
SQL QUERY (SELCET whatever FROM)
If you have same names somewhere, then use qualify*;
Thanks, now I got the result I wanted!
I used:
load*
;
SQL
select "number 1"
;
load*
;
SQL
select "number2"
;
and so on.
A good idea is to give ur load a name, if they all come form same source
eg:
Table1:
load*
;
SQL
select "number 1"
Table2:
load*
;
SQL
select "number2"
;
Great, surprisingly easy and useful!