Re: Complex join problem with lookup table - need Help

>>
>> Doing
>>
>> select * from emergency_role a, emergency_role b where
>> a.Emergency_sq = b. emergency_position_seq_number
>
>Where is the fact table?

it should read

select * from emergency_role a, emergency_responder b where
>> a.Emergency_sq = b. emergency_position_seq_number

>> when I do
>>
>> select * from emergency_role a, emergency_role b where
>> a.Emergency_sq = b.emergency_position_seq_number
>> and
>> a.Emergency_sq = b.alternate_position_seq_number
>
>Where is the fact table?

it should read

select * from emergency_role a, emergency_responder b where
>> a.Emergency_sq = b. emergency_position_seq_number

>> What is the proper way to do this join?
>
>I'm assuming you didn't cut and paste?
>
>select lkp1.descriptive_fld1, lkp2.descriptive_fld1
>from lkp1, lkp2, fact
>where fact.id1 = lkp1.id1
>and fact.id2 = lkp2.id1
>

Thnaks but we only have one dimension table lkp1 not 2, can it be done with just one? Received on Wed Apr 03 2002 - 05:37:06 CST