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.

 All Forums
 Other Forums
 Other Topics
 SQL Server

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 ..."
Go to Top of Page
   

- Advertisement -