[RBG7-L] - Re: Left Outer Join

[Jan Barley]

Albert & David, Again, thanks for your responses.  Right now, I'm under a deadline of tomorrow to finish converting 2 years worth of Peachtree garbage and will be on-site all day tomorrow, but I will try your suggestions when I return and report back where the problem was (hopefully!).   Jan ----- Original Message ----- From: David M. Blocker To: RBG7-L Mailing List Sent: Wednesday, August 25, 2004 5:16 PM Subject: [RBG7-L] - Re: Left Outer Join 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