[RBG7-L] - Left Outer Join

[Jan Barley]

Good morning everyone!   I am trying to do what I think is a simple LOJ with 2 tables - one for members and one for web advertising.  Not all members have web ads, so I created a temp view and LOJ members with webads using the membid as the link between the 2 tables.  For members without a web ad, the view pulls in the last value for the table in webads - I thought it should have nulls.  I added a row of nulls to webads and now it pulls correctly, but I didn't think it should work this way.  Any suggestions? Here's my view:   cre temp vie vws (Membid,Member,Businesstype,Addr1,City,State,Zipcode,Phone,TollFree,WebSite,Email,Descript,+   DateJoin,AdLocation,Logo,LogoLocation) as sel Membid,Member,businesstype,addr1,city,state,zipcode,phone,+   tollfree,website,email,descript,edate,+   AdLocation,Logo,LogoLocation from membs t1 left outer join webads t2 +   on t1.membid = t2.membid where t1.idate >= (.#date)   Thanks! Jan Barley