Re: Need urgent help with sub-query

Hi Martin,

How's it going you red haired scoundrel ;)

In my day, I had three choices with regard to homework:

1. Do it myself (the safest although not always the easiest option)
2. Get my good mate Andrew Brown to do it (although it required the payment of a handful of gobstoppers or a number of football collector cards)
3. Don't do it (the easiest option but one that carried certain unfortunate consequences)

These days, the options are endless and you can't blame someone for trying if certain social obligations (like a night on the grog) has unfortunately gotten in the way ;)

Cheers

Richard
"Martin Doherty" <martin.doherty_at_oracle.com> wrote in message news:3D87C02A.B3F5B240_at_oracle.com...
> Gamaz,
>
> Is this an assignment for school? Is your request urgent because the
deadline
> for completing the assignment is looming closer?
>
> gamaz wrote:
>
> > Hi,
> > I have a worker table from which a correlated subquery needs to be used
to
> > get the youngest worker and the corresponding lodge he/she resides. I
know
> > how to do without using sub-query. However, I could not think as how to
> > resolve it by sub-query. Any help is highly appreciated. Thanks in
advance.
> >
> > Worker table is attached.
> >
> > NAME AGE LODGING
> > ------------------------- ---------- ------------
> > BART SARJEANT 22 CRANMER
> > ELBERT TALBOT 43 WEITBROCHT
> > DONALD ROLLO 16 MATTS
> > JED HOPKINS 33 MATTS
> > WILLIAM SWING 15 CRANMER
> > JOHN PEARSON 27 ROSE HILL
> > GEORGE OSCAR 41 ROSE HILL
> > KAY AND PALMER WALLBOM ROSE HILL
> > PAT LAVAY 21 ROSE HILL
> > RICHARD KOCH AND BROTHERS WEITBROCHT
> > DICK JONES 18 ROSE HILL
> >
> > NAME AGE LODGING
> > ------------------------- ---------- ------------
> > ADAH TALBOT 23 PAPA KING
> > ROLAND BRANDT 35 MATTS
> > PETER LAWSON 25 CRANMER
> > VICTORIA LYNN 32 MULLERS
> > WILFRED LOWELL 67
> > HELEN BRANDT 15
> > GERHARDT KENTGEN 55 PAPA KING
> > ANDREW DYE 29 ROSE HILL
>
Received on Tue Sep 17 2002 - 19:47:21 CDT