Re: Join Question

> "DiggidyMack69" <DiggidyMack69_at_hotmail.com> wrote in message
> news:c86ce4f.0301241104.5f96a423_at_posting.google.com...
> > Hello folks,
> > I am trying to figure out if there is a way to accomplish the join
> > below without doing a subquery of table2. Can someone please show me
> > what I am doing wrong? Is there another type of join using another
> > operator besides the "(+)"?
> >
 "Brian E Dick" <bdick_at_cox.net> wrote in message news:<0ViY9.9016$GX4.488921_at_news2.east.cox.net>...
> select a.id x, a.amount y, b.amount z
> from table1 a, (select id, amount from table2 group by id) b
> where a.id = b.id
>

So this can't be done without a subquery?

DM Received on Mon Jan 27 2003 - 17:21:39 CET