Need urgent help with sub-query

From: gamaz <gamaz_at_earthlink.net>
Date: Tue, 17 Sep 2002 23:40:25 GMT
Message-ID: <J3Ph9.1148$L35.93452@newsread2.prod.itd.earthlink.net>

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.

begin 666 Worker_table.txt

M3D%-12 @(" @(" @(" @(" @(" @(" @(" @(" @(" @04=%($Q/1$=)3D<-
M"BTM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T@+2TM+2TM+2TM+2 M+2TM+2TM
M+2TM+2T-"D)!4E0_at_4T%22D5!3E0@(" @(" @(" @(" @(" @(" @(" R,B!#
M4D%.3452#0I%3$)%4E0_at_5$%,0D]4(" @(" @(" @(" @(" @(" @(" @-#,@
M5T5)5$)23T-(5 T*1$].04Q$(%)/3$Q/(" @(" @(" @(" @(" @(" @(" @
M(#$V($U!5%13#0I*140_at_2$]02TE.4R @(" @(" @(" @(" @(" @(" @(" @
M,S,@34%45%,-"E=)3$Q)04T_at_4U=)3D<@(" @(" @(" @(" @(" @(" @(" Q
M-2!#4D%.3452#0I*3TA.(%!%05)33TX@(" @(" @(" @(" @(" @(" @(" @
M,C<@4D]312!(24Q,#0I'14]21T4_at_3U-#05(@(" @(" @(" @(" @(" @(" @
M(" @-#$@4D]312!(24Q,#0I+05D_at_04Y$(%!!3$U%4B!704Q,0D]-(" @(" @
M(" @(" @(" @4D]312!(24Q,#0I0050_at_3$%605D@(" @(" @(" @(" @(" @
M(" @(" @(" @,C$@4D]312!(24Q,#0I224-(05)$($M/0T@@04Y$($)23U1(
M15)3(" @(" @(" @(" @5T5)5$)23T-(5 T*1$E#2R!*3TY%4R @(" @(" @

M(" @(" @(" @(" @(" @(#$X(%)/4T4_at_2$E,3 T*#0I.04U%(" @(" @(" @ M(" @(" @(" @(" @(" @(" @("!!1T4_at_3$]$1TE.1PT*+2TM+2TM+2TM+2TM

M+2TM+2TM+2TM+2TM+2 M+2TM+2TM+2TM("TM+2TM+2TM+2TM+0T*041!2"!4
M04Q"3U0@(" @(" @(" @(" @(" @(" @(" @(#(S(%!!4$$@2TE.1PT*4D],
M04Y$($)204Y$5" @(" @(" @(" @(" @(" @(" @(#,U($U!5%13#0I0151%
M4B!,05=33TX@(" @(" @(" @(" @(" @(" @(" @,C4_at_0U)!3DU%4_at_T*5DE#
M5$]224$@3%E.3B @(" @(" @(" @(" @(" @(" @(#,R($U53$Q%4E,-"E=)
M3$92140_at_3$]714Q,(" @(" @(" @(" @(" @(" @(" V-PT*2$5,14X_at_0E)!
M3D14(" @(" @(" @(" @(" @(" @(" @(#$U#0I'15)(05)$5"!+14Y41T5.

M(" @(" @(" @(" @(" @(" @-34_at_4$%002!+24Y'#0I!3D1215<@1%E%(" @ A(" @(" @(" @(" @(" @(" @(" @,CD_at_4D]312!(24Q, `
end Received on Tue Sep 17 2002 - 18:40:25 CDT