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 |
|
deathrow
Starting Member
6 Posts |
 Posted - 2010-04-25 : 12:51:34
|
| Hello,sorry this will be my last topic.I have 3 questions that i need to for the listings and i done 2 and started on the 3rd 1.The 3rd question is. List the Trainer's name, the course name and booking date and location of trainingmy answer so far isselect trainer_name, course_name, booking_date, location_lidfrom trainer, course, booking, locationwherecould someone help me pleaseThank You |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-25 : 13:04:04
|
| we can suggest anything unless we know the columns in table and how they are related with other table i.e based on what column------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
deathrow
Starting Member
6 Posts |
Posted - 2010-04-25 : 13:24:38
|
| Ok, for the booking table my columns are "booking, time, employee id, location id"trainer column is "trainer, fee id"course column is "course, course id, course level" location of training column is "location id, location, employee id, employee role"They are related because first we need to book a date, address what trainer is going to be there as well as what course the trainer takes and the level and finally location of the booking.I hope this is what you meantThanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-25 : 13:37:11
|
| which columns are used for relating the tables?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
deathrow
Starting Member
6 Posts |
Posted - 2010-04-25 : 13:59:21
|
| I have no columns related to other tables, i think thats why im struggling, this question is worth 10 marks so i want to get as much from it as i can with what ive got.Is there anything i can do to get some marks? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-25 : 14:59:58
|
| from info you provided there's nothing which represents relation of trainer taking a course on a particular location for a date------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
SQL listing?