I need to union two queries. Of course, my queries need the same number of fields to union properly. Query 1 has employee_id, first_name, and last_name. Query 2 will have employee_id, ‘Vacancy’, ‘Vacancy’. What is the best way to hard code the word ‘Vacancy’ in the first and last name fields if the record is for a job opening? Create universe objects for first and last name? How do I go about it?
Cindy
Cindy Clayton - Business Objects Consultant AT&T
336.698.2144
Give people more than they expect and do it cheerfully. Talk slowly but think quickly.
Smile when picking up the phone. The caller will hear it in your voice. Mind your own business.
Learn the rules then break some.
Judge your success by what you had to give up in order to get it.
Ummm… I don’t think that’s what she was asking. She wants to know how to get her SQL to union correctly so that the query will run.
Cindy - you should be able to create two universe objects that have contants in their SELECT clauses. I think I did this one time a very long time ago in a job far, far away…
Failing that, heck, you can always modify the SQL…
Cindy,
I think you could just create two Dummy objects in your Universe, defined simply as Nulls (’’).
Then you can substitute the first & last name in the second (unionised) query with the two
Dummy objects. Of course, your objects will not compile, but will work fine in the query.
Good luck. Regards, Irena
