Skip to Content
0
Jul 12, 2012 at 02:52 PM

Need Help on derived tables

16 Views

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.