UNION ALL in SELECT Statement

[Anonymous]

Hi all,

Please advise on UNION All in Select query,How to use:

Select

Details1 as Details,

a,

b,

c

From A

UNION ALL

Select

Details2 as Details,

a,

b,

c

From B;

Above statement is not working in load script.

I want to extract data with a select statement

for performance tuning.

Thanks for help

Nitha

[ashfaq_haseeb]

Use Concatenate

Replacement for union

Select

Details1 as Details,

a,

b,

c

From A

concatenate

Select

Details2 as Details,

a,

b,

c

From B;

Regards

ASHFAQ

[ecolomer]

It is possible you ODBC non suport this.

Try with JOIN or CONCATENATE

[rajeshvaswani77]

Nitha,

Try the query first directly on the backed and see if it works?

What error message are you getting?

thanks,

Rajesh Vaswani

[Anonymous]

Hi Ashfaq,

I want to extract data from multiple tables with select statement at the same time so data will be extracted in single table to qlikview.

so concatenate can be done only after extracting all tables to qlikview.

Thanks

Nitha

[Anonymous]

Hi Rajesh,

Yes i have queried in backend and used same query in qlikview script.

But still it doesn't work

Thanks

Nitha

[Anonymous]

There is no error and only first table is extracted

[rbecher]

What is the source database system?

- Ralf

[Anonymous]

Hi Ralf,

Its oracle.

[rajeshvaswani77]

Check if you have given SQL and terminated with quote. Otherwise it should work. Could be possibly to do with the driver then.

thanks,

Rajesh Vaswani