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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-23 : 09:40:13
|
| christel writes "How do i write sql statement to list holidayID, country, accommodationID and accommodation description for all holidays with a duration greater than 10 days.2.How do i write one sql statement to joins three tables together.3. How do i write an sql statement using GROUP BY that would provide the average holiday cost for each (i.e accommodation type).Thank you" |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-08-23 : 09:43:44
|
First - Have you tried? If yes - post what you have so far!Second - In order to get a reasonable answer you should include a few details... like table definitions, sample data, expected results...Thanks!Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
 |
|
|
|
|
|
SQL Server