[RBG7-L] - Re: Left Outer Join

[David M. Blocker]

Jan   I agree with Albert's posting, but also to help see where things are going wrong.  Put the t1, t2 in front of each column name after select and put it back up on line so we can look at it.   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Jan Barley To: RBG7-L Mailing List Sent: Wednesday, August 25, 2004 9:02 AM Subject: [RBG7-L] - Left Outer Join 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