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 |
|
Thevenine
Starting Member
1 Post |
 Posted - 2005-04-09 : 11:06:22
|
| now i have two tables...one is called the Profile table which contains information like PatientID,Name,AGe Gender,address and etc... ~ and the second table is an Empty table linked to the profile table through the PatientID ~The Empty table has a field called PulseRate ~ whereby the data will be receive and stored in that column/field from an external source;an ECG machine ~ Now the Problem is that...the data from one ECG machine is stored in the same column, continuously downwards ~ what i mean is that the entire PulseRate column is storing the one and same data from one and same ECG machine...the same data being spread into several parts in different rows ~Though i supposingly to create something like viewing each patient's pulserate by selecting their PatientID ~ but since the problem is as mentioned above ~ in the profile table when i try to view the pulserate by clicking on the +/- signs which appears after linking with the two tables... ~ it only view that particular Row ~ which means only a small portion of the data received from the same ECG machine... ~ and the next patientID will be displaying the next small portion of the received data and the same for the other PatientID ... PLease Anyone has any good suggestion in solving this matter???please tell me...or anyone who still are not clear of the problems i described please let me know...im running short in time so plz...anyone any guides or advice is very much appreciated |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2005-04-09 : 14:00:15
|
| How bout using view instead of using (+) mark ?if u choose the ID No. 1 then view the data in Pulserate with ID = 1 ? Use outer join to do this"select * from profile a left join pulserate b on a.patientid = b.patientid" |
 |
|
|
|
|
|
A Linking between two tables problem...