I don't know? But I'll give it a shot...thanks!
Dian D. Chapman, Technical Consultant Microsoft MVP, Certified MOS Expert Editor/TechTrax Ezine Free Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: www.mousetrax.com/books.html Optimize your business docs: www.mousetrax.com/consulting Learn VBA the easy way: www.mousetrax.com/techcourses.html -----Original Message----- From: Dan Powderhill [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 9:24 AM To: [EMAIL PROTECTED] Subject: RE: [ASP] SQL Query Syntax HELP! Shouldn't your inner join statement come before your where clause? Dan -----Original Message----- From: Dian D. Chapman [mailto:[EMAIL PROTECTED] Sent: 10 December 2004 15:05 To: Group - ASP Subject: [ASP] SQL Query Syntax HELP! The last query in this monster...but I need help, please! I'm getting: Syntax Error (missing operator) And I'm not sure I'm doing the join correctly??? My eye are crossing and I can't figure out what I'm messing up now. Really appreciate some help... gstrSQLQuery = _ "SELECT * FROM Referrals WHERE (" _ & "(Referrals.TellerID=" & "'" & strSingleTeller & "') " _ & "AND (Referrals.Sales='True') " _ & "AND (Referrals.ReturnDate BETWEEN (" _ & "'" & varReportFromDate & "' AND " _ & "'" & varReportToDate & "'))" _ & ") INNER JOIN Customer ON Referrals.CustomerID=" _ & "Customer.CustomerID ORDER BY TellerID" Dian ~ -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004 --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004 -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004 ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
