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!
Query health hospital HELP!
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.