Date:         Mon, 29 Aug 2005 14:11:25 -0400
Reply-To:     "Luo, Peter" <pluo@DRAFTNET.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Luo, Peter" <pluo@DRAFTNET.COM>
Subject:      Which SQL run faster

Proc sql;

select A.*

from A left outer join B

on A.id=B.id

where A.age<=60

;



or



Proc sql;

select A.*

from (select * from A where age<=60) a left outer join b

on a.id=b.id

;



Thanks