[RBG7-L] - Re: Left Outer Join

[David M. Blocker]

Jan   Your syntax looks fine.   Three things to try:   1.  Pack KEYS on the database - you might have a damaged index 2.  Try the select itself as is - do you get the same problem? 3.  Try placing the ENTIRE WHERE CLAUSE in parens instead of parens around .#date:   WHERE (T1.IDate >= .#date 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 3:17 PM Subject: [RBG7-L] - Left Outer Join 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