AnsweredAssumed Answered

Custom Portlet Lookup Joins

Question asked by itslsoto on Oct 13, 2011
Latest reply on Oct 17, 2011 by itslsoto
All,

I am building a portlet to display user friendly content for column information currently stored as you_are_not_cool to come out more like You Are Cool.

Iam working with the table odf_ca_project column Stage. The value in column Stage is currently stored as go_gREEN. I found the user friendly value in CMN_Lookups - Go Green.

However when I try to join odf_ca_project with CMN Lookups it outputs repetitive data.

my code looks something like this:
Select A.Name, B.Name

From ODF_CA_PROJ A, CMN_LOOKUPS B

where A.Stage=B.Lookup_type
Expect result is:

Project A Go Green

I am getting:

Project A Go Green
Project A Go Green
Project A Go Green
Project A Go Green
Project A Go Green

Outcomes