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 |
|
fdgraft1
Starting Member
1 Post |
 Posted - 2012-01-07 : 23:42:06
|
| Hi Guys,I need help writing out the query below. Also I am new to SQL Server Management Studio 2008 and would appreciate it if someone will be able to help me navigate the SSMS, show me how the various features work: Thanks,fdgraft-- Write and execute a query to retrieve the member’s full name and member_no from the Member table and the ISBN and log_date values from the Reservation table for member numbers 250, 341, and 1675. Order the results by member_no and log_date. You should show information for these members, even if they have no books on reserve.Francis Dickson |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-08 : 02:37:29
|
| how do you think someone will be able to help you on this without knowing any of your table structures and data it has? Start with reading about joins in books online/MSDN and try it out yourself (the requirement above sounds like straightforward implementation of join). In case you face any issue, post tried query with sample data and required output.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-01-09 : 02:33:40
|
| All you have to do is to join related tables with common key and get required columnsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL Server query