Re: Select question

Karsten Farell wrote:

> You need to do the following analysis of the problem:
>
> 1. What field is common to both tables? Use that to join the two tables.
> Give each table an alias so you can refer to columns in each table by
> that alias.
> 2. What restrictions do I want to put on my output? Use that in your
> 'where' clause. Don't forget to use the table alias you assigned above
> so Oracle will be able to distinguish between the common field (which,
> in this case, has the same name in both tables).
> 3. What output do I want to see? Use that in your 'select' clause.
>
> I could write the SQL for you ... but I've been chastised before for
> doing that. ;)
>
> CD - ROM wrote:
> > Dear All
> >
> > I have the follow table:
>
> ...[snip copy of homework assignment]...
>
> > I want to write a SQL to list the borrowermemno of all the members
> > who have borrowed all titles written by "Collins."
> >
> > Please give me some idea.
> >
> > Thanks for your help!
> >
> > Tony
> >
> >

And I, for one, note and greatly appreciate your response.

Daniel Morgan Received on Fri Sep 27 2002 - 11:59:35 CDT