Hi, I'm new to Oracle pl/sql developer .I'm trying to make a report from table apps.per_people_x where there are three columns that have IDs and their values can be gotten from another table called apps.FND_LOOKUP_Values . I made three aliases from the table apps.FND_LOOKUP_Values flv ,lookup and lvalue
and i query :
select distinct
flav.meaning Nationality,
lookup.meaning Registered_disabled,
lvalue.meaning Country_of_Birth
from apps.per_people_x b,
apps.FND_LOOKUP_Values flv,
apps.FND_LOOKUP_Values lookup,
apps.FND_LOOKUP_Values lvalue
where
--to get nationality
--and flv.lookup_Type='LANGUAGE'
and b.NATIONALITY = flv.lookup_code
--to get regestered diabled
--and lookup.lookup_type = 'REGISTERED_DISABLED'
and b.REGISTERED_DISABLED_FLAG = lookup.lookup_code
--to get country of birth
--and lvalue.lookup_type = 'PER_US_COUNTRY_CODE'
--and b.COUNTRY_OF_BIRTH = lvalue.lookup_code
but it gets zero rows .although when i hashed everything and just use a single condition of those b.Nationality = flv.lookup_code,it works and gets data in Nationality column but with each other it doesn't get anything .what should i do ?