SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

kevin1993
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

visakh16
Very Important crosS Applying yaK Herder

India
52317 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
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000