Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Join 3 tables
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 04/13/2013 :  01:01:07  Show Profile  Reply with Quote
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

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 04/13/2013 :  01:44:43  Show Profile  Reply with Quote
you need to first make a try. Otherwise we wont help with assignment questions.

SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000