Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Some beginner's help please?
Randy wrote:
> 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.
> >
>
> Ahhh.. Thanks for the complement guys, but I'm 42, have 2 grandchildren,
> and haven't been in school for 20 years (well, the odd Cisco class). This
> tells me this must be REALLY simple, so I'll take the hint and dig around
> on table aliasing (btw, the actual query is much more complicated, I just
> simplified it down some for clarity. I'm actually pulling data from several
> tables and formatting it out to a HTML page that runs the query on a CRON
> job every hour.. did I mention I've been a unix sysadmin for the last 10
> years also..)
>
> you guys make a fella feel young... lol
That's because compared to me you are. ;-)
But unless your ISP charges by the character ... post as much information as someone will need to actually hellp you.
Daniel Morgan
http://www.extension.washington.edu/extinfo/certprog/oad/oad_crs.asp
Received on Fri Oct 18 2002 - 12:28:59 CDT