Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kifeda
Posting Yak Master
136 Posts |
 Posted - 2007-11-20 : 15:03:58
|
| I have a table tblclients where all my client information is. In my application, I can assign a client to a therapist which is simply inserting the client id (intclientId) into the table with the inttherapistId and the authorid was completed the transaction. because we want to know the history of the transfers, I have to have a separate table other wise I could have just crated a field in the client table for the therapist id.Simply enough.The problem is when I assign the client to a therapist more than once, on the client log (the screen that shows all my clients) the client appears twice- once for each therapist he has been assigned to. I only want the client to appear once- and show the name of the latest therapist he has been assigned to not all the therapist. The way I did the select was to do an left outer join on the tbltransfer based on the client id. Works but like I said it gives me the client twice, if I assign them to the therapist more than once. So here is my statement:select c.strfirstname, c.strlastname, c.intlocationId from tblclients c left outer tbltransfer t on t.intclientId = c.intclientIdthis works, but if I have more than one record for the same client in the tbltranfer (if I assign the client more than once) then the recordset that is returned contains two records- one for each therapist assigned and that my problem.Any help would be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-20 : 15:11:47
|
| Post sample data that illustrates your problem.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
limit problem