[RBG7-L] - Left Outer Join

[Jan Barley]

Albert & David, Thanks for the response.  I cut down the number of fields for simplification and added the correlation before each field and still get the same results.  The view I am creating is as follows:   cre temp vie vws (Membid,Member,Businesstype,AdLocation) as sel +   t1.Membid,t1.Member,t1.businesstype,t2.AdLocation +   from membs t1 left outer join webads t2 on t1.membid = t2.membid +   where t1.idate >= (.#date)   Any input would greatly be appreciated!!! Thanks. Jan