Click here to Skip to main content
15,867,851 members
Home / Discussions / Database
   

Database

 
AnswerRe: Case Sensitive User Name Pin
Luc Pattyn11-Aug-09 3:30
sitebuilderLuc Pattyn11-Aug-09 3:30 
QuestionHow to change the default port 1433 for SQLServer 2008 Pin
Paramu197311-Aug-09 1:03
Paramu197311-Aug-09 1:03 
AnswerRe: How to change the default port 1433 for SQLServer 2008 Pin
Paramu197311-Aug-09 4:18
Paramu197311-Aug-09 4:18 
QuestionHow to Concate more than one rows in one row ?. Pin
Fazal Vahora10-Aug-09 21:41
Fazal Vahora10-Aug-09 21:41 
AnswerRe: How to Concate more than one rows in one row ?. Pin
infneeta10-Aug-09 23:46
infneeta10-Aug-09 23:46 
QuestionOuter Join issues Pin
Mustafa Ismail Mustafa10-Aug-09 4:45
Mustafa Ismail Mustafa10-Aug-09 4:45 
AnswerRe: Outer Join issues Pin
leckey10-Aug-09 5:26
leckey10-Aug-09 5:26 
GeneralRe: Outer Join issues Pin
Mustafa Ismail Mustafa10-Aug-09 5:44
Mustafa Ismail Mustafa10-Aug-09 5:44 
More like merge them but with the repeated columns removed (PatientID & AdmittanceID).

In a way, I'd want results of the query to be as such: (based on the tables given in the OP)

(Table1) (Table1) (Table1) (Table2)
PatientID AdmittanceID SymptomID Symptom
============================================================
1234 1 1 NULL
1234 1 3 NULL
1234 1 NULL This is a symptom



Makes sense?

[Edit] I just realized that the tables aren't very clear. Try this:

Table 1

PatientIDAdmittanceIDSymptomID
123411
123413


Table 2

PatientIDAdmittanceIDIDSymptom
123411This is a symptom


Wanted result

PatientIDAdmittanceIDSymptomIDSymptom
123411NULL
123413NULL
12341NULLThis is a symptom


What I get:


PatientIDAdmittanceIDSymptomIDSymptom
123411This is a symptom
123413This is a symptom


If the post was helpful, please vote, eh!

Current activities:
Book: Devils by Fyodor Dostoyevsky
Project: Hospital Automation, final stage
Learning: Image analysis, LINQ

Now and forever, defiant to the end.
What is Multiple Sclerosis[^]?

GeneralRe: Outer Join issues Pin
DoctorMick10-Aug-09 6:28
DoctorMick10-Aug-09 6:28 
GeneralRe: Outer Join issues Pin
Mustafa Ismail Mustafa10-Aug-09 9:34
Mustafa Ismail Mustafa10-Aug-09 9:34 
GeneralRe: Outer Join issues Pin
i.j.russell10-Aug-09 8:12
i.j.russell10-Aug-09 8:12 
GeneralRe: Outer Join issues Pin
Mustafa Ismail Mustafa10-Aug-09 9:41
Mustafa Ismail Mustafa10-Aug-09 9:41 
GeneralRe: Outer Join issues Pin
leckey10-Aug-09 8:38
leckey10-Aug-09 8:38 
Questioncustom query Pin
sujithkumarsl9-Aug-09 23:45
sujithkumarsl9-Aug-09 23:45 
AnswerRe: custom query Pin
Mycroft Holmes10-Aug-09 3:04
professionalMycroft Holmes10-Aug-09 3:04 
GeneralRe: custom query Pin
Luc Pattyn10-Aug-09 3:34
sitebuilderLuc Pattyn10-Aug-09 3:34 
QuestionConnection String Pin
John.L.Ponratnam9-Aug-09 23:34
John.L.Ponratnam9-Aug-09 23:34 
AnswerRe: Connection String Pin
SeMartens10-Aug-09 0:31
SeMartens10-Aug-09 0:31 
Questionlost data base Pin
Tauseef A9-Aug-09 23:09
Tauseef A9-Aug-09 23:09 
AnswerRe: lost data base Pin
SeMartens10-Aug-09 0:33
SeMartens10-Aug-09 0:33 
QuestionDTS to Import .SQL file Pin
Paul Hayman9-Aug-09 22:28
Paul Hayman9-Aug-09 22:28 
AnswerRe: DTS to Import .SQL file Pin
Mycroft Holmes10-Aug-09 3:08
professionalMycroft Holmes10-Aug-09 3:08 
GeneralRe: DTS to Import .SQL file Pin
Paul Hayman10-Aug-09 18:21
Paul Hayman10-Aug-09 18:21 
GeneralRe: DTS to Import .SQL file Pin
Mycroft Holmes10-Aug-09 18:29
professionalMycroft Holmes10-Aug-09 18:29 
GeneralRe: DTS to Import .SQL file Pin
Paul Hayman10-Aug-09 18:47
Paul Hayman10-Aug-09 18:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.