Is iDate in t1 or t2? Have you tried the SELECT clause in a stand alone command file? I often do this and keep changing one little thing at a time until I find the offending boo-boo.
Start with SELECT MembID FROM Membs WHERE iDate >= .#DATE Then SELECT t1.MembID, t2.AdLocation + FROM Membs t1 LEFT OUTER JOIN WebAds t2 + ON t1.MembID = t2.MembID etc. --- Jan Barley <[EMAIL PROTECTED]> wrote: > 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 > ===== 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]
