How to make append query ?

[Recce]

Hi,

I know this is a silly quetion but, I had never done this before. I need to make an append querie of more that one table i.e hotfiles like one would do in MS Access. Can anyone tell me how to do this in Impromptu ?

Thanks

:->

 

[griffindm]

Recce,

Impromptu cannot do this easily on it's own. A better solution is to create a union view in your database and let Impromptu access that as a normal data source.

I believe I have some examples of union view SQL syntax in the Prompt FAQ.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[Recce]

Hi Dave

Thanks for this. I will look at the FAQ's SQL Union....