cancel
Showing results for 
Search instead for 
Did you mean: 

Need Help on derived tables

former_member184582
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hello,

Whats the error u get. Can u copy the complete syntax here

REgards,

Laxminarayana