I have a query that is pulling from two tables that are joined with a one to one relationship by the account/credit card number. I have a patient that was entered twice because he paid two different balances. The query is returning his name twice for each entry instead once for each entry. Can someone help me with this... I can e-mail the database to you so you can see what I am talking about.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query is pulling double results 1
- Thread starter Buddha1
- Start date
- Status
Similar threads
