Try specifically assigning the table aliases in the view definition. SELECT ... t1.MembID, ...
--- Jan Barley <[EMAIL PROTECTED]> wrote: > 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 > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
