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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Join 3 tables

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 do
1. 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). Show
these appointments in date & time order

There are doctor,patient and appointment table.

2. Create a view called “todays_appointments”. The view should list all appointments for the
current day. Include the appointment date and time, the doctor’s name, the patient’s name
and phone number, and done field. Order the view into doctor’s name, then order by the
appointment time.


3. List all appointments made by patients in the suburb RICHMOND, during the 2010 year
that have not been diagnosed with any diseases. Show the name of the patient and the date
and 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -