Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I do this 2-table combined query?

Re: How do I do this 2-table combined query?

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 1 Sep 2005 07:29:40 -0700
Message-ID: <1125584980.081850.34690@g44g2000cwa.googlegroups.com>

RK wrote:
> IANAL_VISTA wrote:
> > "RK" <rekaben_at_yahoo.com> wrote in
> > news:1125498254.823545.163300_at_g49g2000cwa.googlegroups.com:
> >
> > ...
> >
> > The homework tutor is down the hall on the left.
> > Why is table T2 in the FROM clause when no data is being selected from it?
>
>
>
> Sorry, what I want to get is like:
>
> select b.nm (for a.f1 in the row), b.nm (for a.f2 in the row)
> from t1 a, t2 b
> where a.f1 = b.cd and a.f2 = b.cd
>
>
> But if I do it like above, of course, I wont' get the info I want. Hope
> I said it clearly this time.
>
> Any help. Thanks.

HINT: you need to join table t2 more than once. (IE it will be in the FROM clause more than once)

HTH,
  ed Received on Thu Sep 01 2005 - 09:29:40 CDT

Original text of this message

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