Hi folks... 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.
I have these tables (for a vet clinic): CLIENT - human client info (no PatientID relationship here) PATIENT - animal patient info (no ClientID relationship here) OWNER - tables that matches PatientID <-> ClientID I need to get all the client and patient info matching the LASTNAME (client) entered into the search, so I can present a list of matches with details, including client name, address...plus...pet names, sex, species. If the client or patient table had a linked ID, I know how to do that. But I'm not sure how to do this now with the third table being the match. TIA for any help... Dian ~ -- 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/
