Universe & joins

View previous topic View next topic Go down

Universe & joins

Post  Afaf on Mon Oct 01, 2012 8:11 pm

Issue:

Need to do a left outer join in the where clause of a dimension object

Description:

- There are two tables in the database schema that contain the Log-in ID of a user
- Lets say Table A contains the Log-id ID and some other info whereas Table B also contains the Log-in ID and the user's first and last name
- The requirement is to show the user's First name and last name along with the log-in ID and other info from Table A
- In the Universe, Tables A and B are not joined
- Instead a dimension object has been created with the select clause as:

select table.first_name||' ' ||table.last_name

- And in the where clause the condition is specified as:

Table A.log_ID = TableB.Log_ID

- According to me, this works however brings is incorrect results at some places
- I suggested that we create an Alias table or somehow do a Left Outer join to the Table B
- I don't see how this can be achieved without actually joining the tables and placing the join condition in the where clause.

But ,
Righting case statement sounds good the only question how can I right an outer join in the statement ?

Because what I am trying to do is : I need to compare values between those 2 objects. But also for one of the other object I want to return the rest of the data ?

Plz reply soon Experts,
Have a great day ahead !

Afaf

Posts : 14
Join date : 2012-09-18

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum