Query health hospital HELP!

[expired user #8537]'s profile image [expired user #8537] posted 9 years ago in General Permalink
Hi I need to create a query and I urgently need your help!
I have these tables:
1)Base data...that contains:First name, last name, date of birth, medical record number.
2)Department Laboratory Analysis, that contains: name, last name, date of birth, medical record number, exam date, examination.
3)Radiology department, that contains: name, last name, date of birth, medical record number, exam date, examination.
4)department transfusion that contains: name, last name, date of birth, medical record number, exam date, examination.
5)Pathology department that contains: name, last name, date of birth, medical record number, exam date, examination.
and other department.

I would like to have in a single row (not column), the name, surname, date of birth, type of examination of each department, and the day of execution of the examination.
Can you help with the query?
Thanks much for who my help!
jfalch's profile image jfalch posted 9 years ago Permalink
not possible as a single row using sql.
[expired user #8537]'s profile image [expired user #8537] posted 9 years ago Permalink
And how can I fix?
jfalch's profile image jfalch posted 9 years ago Permalink
what would you consider a "fix" ?
[expired user #8537]'s profile image [expired user #8537] posted 9 years ago Permalink




[expired user #8537]'s profile image [expired user #8537] posted 9 years ago Permalink
How can I have an entire row with all the exams of the recovery period. From the hospital to the exit, I would like to see everything that has made examinations.
jfalch's profile image jfalch posted 9 years ago Permalink
this here is a support site for a particular mysql database client program, its errors, features and the like. it is mostly not a "teach sql to beginners" site, and it is is very definitely not a "provide solutions to my database workflow" problems. Seek elsewhere. if you "I would like to see everything that has made examinations", i suggest you get a book on sql and start experimenting, as everyone else does.

Please login to leave a reply, or register at first.