Re: Select question

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
>
>
Received on Fri Sep 27 2002 - 11:23:26 CDT