Re: Need urgent help with sub-query

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