Re: Complex join problem with lookup table - need Help

On 3 Apr 2002, asd_at_sds.com wrote:
>>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?

I'm sorry for putting it that way. Consider joining your lkp table twice was the example. If you think about a where clause like

from lkp t1,lkp t2, fact

I think it will then make sense.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.