union query

[ruma20045]

I am required to create a union query and I am pretty new to crystal. Can some body point out how to achieve this.

 

[Turkbear]

Hi,
More info please:

Crystal Version
Database type and Version
What kind of union ( or is it really a join?)

What is the task ( input and Output) you need to accomplish?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

As turk pointed out, the method depends upon your version of Crystal.

In CR 8.X, you can modify the Database->Show SQL Query, in later versions use the Add Command object to create your own query from scratch.

You'd be best served to create the query on the database side as a View (or Query in Access).

In the future, please post technical information.

-k

 

[ruma20045]

My question is how can I combine 2 different queries in crystal

 

[Turkbear]

Hi,
and our questions were:
Crystal Version
Database type and Version
What kind of union ( or is it really a join?)

So, we can only guess what may work...

Try one of Synapse's methods..




To Paraphrase:"The Help you get is proportional to the Help you give.."