How are the tables related ?
There must be some Primary Key -Foreign Key reln between them i
suppose.
If you can find that then this becomes easy.
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.
Received on Wed Aug 31 2005 - 23:47:12 CDT
