The outer join will bring in everything from the right hand table. If you need the outer join to display records without grants,
LEFT OUTER JOIN (Select * from FinancialAid00 where grantamount <> 0) T_2 on .... "Bob Powell" <[EMAIL PROTECTED]> wrote: >Hello everyone: > >I have the following statement which does the outer join properly it just doesn't >limit it to records with grantamounts greater than zero. I get all records >regardless of grant amount. Any ideas! > >CREATE VIEW FinVw00 as + >SELECT T_1.StuId,T_1.StuFirst, T_1.StuLast, T_1.StuStat, + > T_2.* FROM entry00 T_1 LEFT OUTER JOIN + > FinancialAid00 T_2 on T_1.Stuid = T_2.Stuid where T_2.grantamount > 0 > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
