Hello Everyone and thanks for your help in advance. I am wokring on a query that unfortunately, I am unable to post any data due to privacy issues (albeit test data). However, here is what I am trying to accomplish. Let's assume I make an initial single query to the tblPatientVisit table

Select MRNumber From tblPatientVisits Where VisitDate > '1/1/2005'

Should return numerous records to the tune of

MRNumber

3122

3122

3122

etc.

I now want to take the results of this query (it should return several thousand records with multiple occurrences of the same MRNumber) and query it against the tblPtmstr table to return each individual visit's zip code. For example:

MRNumber Zip Code

3122 34120

3122 34120

3122 34120

TI've tried numerous JOINS but always seem to miss data. Thanks for the assistance.

hmmm. What is the relationship tblPatientVisit and tblPtmstr? Assuming that there is a relationship between the 2 tables based on the column MRNumber this should work:

SELECT
   v.MRNumber,
   p.ZipCode
FROM tblPatientVisit v
LEFT JOIN tblPtmstr p on v.MRNumber = p.MRNumber
WHERE Convert(varchar(10), v.VisitDate, 101) = '01/01/2005'

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========