Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> But I have just one lookup table not 2 Re: Complex join problem

But I have just one lookup table not 2 Re: Complex join problem

From: fd <asd_at_sds.com>
Date: 3 Apr 2002 05:40:08 -0600
Message-ID: <3caae973$0$2125$45beb828@newscene.com>

>select lkp1.descriptive_fld1, lkp2.descriptive_fld1
>from lkp1, lkp2, fact
>where fact.id1 = lkp1.id1
>and fact.id2 = lkp2.id1
>

have just 1 lookup table Received on Wed Apr 03 2002 - 05:40:08 CST

This message: [ Message body ]
Next message: Niall Litchfield: "Re: BLOBs as separate tablespace"
Previous message: fd: "Re: Complex join problem with lookup table - need Help"
In reply to: Galen Boyer: "Re: Complex join problem with lookup table - need Help"
Next in thread: Patrick Meyer: "Re: Complex join problem with lookup table - need Help"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US