Re: Some beginner's help please?

Randy wrote:

> I have this query I've been trying to write all week and had no success.
> Here's the problem.
>
> In table "A" I list a TRBLTKT number, CREATEDBY number and CLOSEDBY number.
> The Createdby and Closedby numbers join over to another table called
> PERSONAL, that has IDNUM, LASTNAME and FIRSTNAME as fields.
> My problem is, how do I write a select that resolves the Createdby and
> closedby numbers seperately (if they were different people).
> For one, I'd do:
> select a.trbltkt, personal.lastname from
> a, personal where a.createdby = personal.idnum;
>
> how do I write it to match both fields.. I'm stumped.. help please...
>
> Randy

This appears to me to be a homework assignment and I, and others I suspect, will gladly help you but we try not to do people's homework for them.

Post your best shot at it and we will give you pointers as to what to do next to get the correct solution. Be sure to tell us what version of Oracle as the solution may be different in 8i from 9i.

Daniel Morgan Received on Fri Oct 18 2002 - 12:03:27 CDT