| 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
|
