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

From: RK <rekaben_at_yahoo.com>
Date: 31 Aug 2005 18:19:28 -0700
Message-ID: <1125537568.239666.28290@g49g2000cwa.googlegroups.com>

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 - 20:19:28 CDT