on 07-12-2012 3:52 PM
Hi friends,
I want to create a derived table in the universe designer.
I have 2 tables with some columns and i want to include columns from both the tables.
I have used this syntax
select class1.object1 as Header1 from tablename
union
select class2.object2 as Header2 fromtablename
But i am getting an error msg.
In simple words i want to write a sql query that includes columns from 2 different tables.
Thank You.
Hi,
We can join two tables and write a SQL for creating derived tables. Please post the error message so that we can look at the error and give you a solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Whats the error u get. Can u copy the complete syntax here
REgards,
Laxminarayana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.