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 |
kevin1993
Starting Member
1 Post |
Posted - 2013-04-13 : 01:01:07
|
Hi, this is my first time learn SQL and I can not do my work.How to do1. Show a list of appointments for June 2011. Provide the doctor and patients full name,disease name (if any diagnosed), date & time of appointment together in this format‘YYYY-MON-DD HH:MM’, consultant room number used, and status (i.e. Done). Showthese appointments in date & time orderThere are doctor,patient and appointment table.2. Create a view called “todays_appointments”. The view should list all appointments for thecurrent day. Include the appointment date and time, the doctor’s name, the patient’s nameand phone number, and done field. Order the view into doctor’s name, then order by theappointment time.3. List all appointments made by patients in the suburb RICHMOND, during the 2010 yearthat have not been diagnosed with any diseases. Show the name of the patient and the dateand time of the appointment.There are patient, appointment and disease table.Please the help.Thank you |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-13 : 01:44:43
|
you need to first make a try. Otherwise we wont help with assignment questions.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|