Thanks...I'll give it a shot. APPRECIATE the help! Dian D. Chapman, Technical Consultant Microsoft MVP, MOS Certified Editor/TechTrax Ezine
Free Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: http://www.mousetrax.com/books.html Optimize your business docs: http://www.mousetrax.com/consulting Learn VBA the easy way: http://www.mousetrax.com/techcourses.html -----Original Message----- From: Shawn K. Hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 12, 2005 1:21 AM To: [email protected] Subject: RE: [ASP] SQL query help - with 3rd linking table? Hi Dian, > I need to pull everything from two tables in a very > convoluted DB. This DB was set up was with a third > table as the matching ID table. I only used this > method once before a long time ago...so I'd > appreciate some help figure out how to write this > out. Try this: sSql = "SELECT client.*, owner.*, patient.* FROM (client INNER JOIN owner ON client.clientid = owner.clientid) INNER JOIN patient ON owner.patientid = patient.patientid WHERE ( ( (client.lastname)='" & sLastName & "' ) );" Regards, Shawn K. Hall http://12PointDesign.com/ http://ReliableAnswers.com/ '// ======================================================== "Whenever you find that you are on the side of the majority, it is time to reform." -- Mark Twain --------------------------------------------------------------------- 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.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 --------------------------------------------------------------------- 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/
