Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I do this 2-table combined query?
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