Re: Some beginner's help please?

From: Randy <dmnelson50_at_hotmail.com>
Date: Fri, 18 Oct 2002 17:14:49 GMT
Message-ID: <Xns92AB784AF40E8dmnelson50hotmailcom@24.94.165.87>

Ken Denny <ken_at_kendenny.com> wrote in
news:Xns92AB85A5F14BCkendenny_at_65.82.44.8:

> Daniel Morgan <dmorgan_at_exesolutions.com> wrote in
> news:3DB03ED4.6F67CB81_at_exesolutions.com: 
> 
>> 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.
> 
> I agree with Daniel, but I'll give you a small hint: table aliasing.
> 

BTW, I should mention I do NOT have any write access to this database, it's a read only status for me.

                                                            Randy Received on Fri Oct 18 2002 - 12:14:49 CDT