build union query in Cr9.2 1

[mverdera]

I cannot see a query editor. The query I have to write is too complicated to use the drag and drop method. I know this feature was in 8.5. But what about 9.2.

Thanks
Mark

 

[synapsevampire]

It's slightly different, once you connect to your data source, you'll see the Add Command, click it and you can paste in any SQL statement, a vast improvement over 8.5

-k

 

[mverdera]

thanks, that was quick, I will give it a try.

 

[synapsevampire]

<Shrug>

It's lunchtime so I'm reading through all of the posts.

You should find the new approach much more flexible.

I generally suggest that people create Views/Queries on the database side though.

-k

 

[mverdera]

synapsevampire,
I just did a simple union query. It worked for that. But then I did a more complicated query and it produced an error.

select fld1, count(fld1) as fld_cnt
from
(
select fld1 from table1
union
select fld1 from table2
)

the inner query worked, but failed when added to outer query.

thanks,

 

[mverdera]

figured out my own problem, needed a group by statement. thanks