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 |
|
kemi2299
Starting Member
41 Posts |
 Posted - 2008-07-08 : 07:05:41
|
| hi guys,could you pls have a look at this problem :i am from this statement below, I am trying to find patient with different postcode record in the same spellselect Mrn,CDS_APC_Id,Spell_Num,Start_Dt,Ep_Start_Dt,a.Usual_Address_PostCode --as b2 Usual_Address_PostCode from dbo.CDS_APC ainner join dbo.CDS_APC a on p1.mrn=a.mrninner join dbo.IM_PATIENT p1 on p1.Usual_Address_PostCode = a.Usual_Address_PostCode |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-08 : 13:28:22
|
| Unless you provide sample data from your table and post what you're trying to get, it would be really difficult to tell. We know nothing about your tables and how they are related. |
 |
|
|
|
|
|
duplicate record