As it goes...I got one error fixed...which moved me on to the next.<sigh>
Any ideas on this one? Exact error: "Syntax error in JOIN operation." Here's the query code: gstrSQLQuery = _ "SELECT csdbo_CLIENT.lastname, csdbo_CLIENT.firstname, " _ & "csdbo_CLIENT.m_address1, csdbo_CLIENT.m_address2, csdbo_CLIENT.m_city, " _ & "csdbo_CLIENT.m_state, csdbo_CLIENT.m_postalcode, csdbo_PATIENT.patientid, " _ & "csdbo_PATIENT.name, csdbo_PATIENT.sexid, " _ & "csdbo_PATIENT.color, csdbo_PATIENT.birthdate, csdbo_PATIENT.speciesid, " _ & "csdbo_PATIENT.breedid " _ & "FROM csdbo_CLIENT, csdbo_PATIENT INNER JOIN csdbo_OWNER ON " _ & "csdbo_CLIENT.clientid=csdbo_OWNER.clientid " _ & "WHERE csdbo_PATIENT.patientid=" & Chr(39) & gstrPatientID & Chr(39) _ & "AND csdbo_CLIENT.clientid=" _ & Chr(39) & gstrClientID & Chr(39) Which results in this query string: SELECT csdbo_CLIENT.lastname, csdbo_CLIENT.firstname, csdbo_CLIENT.m_address1, csdbo_CLIENT.m_address2, csdbo_CLIENT.m_city, csdbo_CLIENT.m_state, csdbo_CLIENT.m_postalcode, csdbo_PATIENT.patientid, csdbo_PATIENT.name, csdbo_PATIENT.sexid, csdbo_PATIENT.color, csdbo_PATIENT.birthdate, csdbo_PATIENT.speciesid, csdbo_PATIENT.breedid FROM csdbo_CLIENT, csdbo_PATIENT INNER JOIN csdbo_OWNER ON csdbo_CLIENT.clientid=csdbo_OWNER.clientid WHERE csdbo_PATIENT.patientid='2815'AND csdbo_CLIENT.clientid='2830' TIA for any help... Dian ~ View Hurricane Humane Updates: http://www.mousetrax.com/pets.html -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.9/116 - Release Date: 9/30/2005 ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/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/
