- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Uploading multiple queries from same source
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LOAD yourtables
SQL QUERY (SELCET whatever FROM)
If you have same names somewhere, then use qualify*;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, now I got the result I wanted!
I used:
load*
;
SQL
select "number 1"
;
load*
;
SQL
select "number2"
;
and so on.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great, surprisingly easy and useful!