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
 General SQL Server Forums
 New to SQL Server Programming
 Search.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-14 : 09:36:56
David writes "Hi,
Here is what I wanted to do. Let's take a case.
We have a table of teams.

TEAMS:
---------
IDTEAM
TEAM_NAME


A table stades:
STADES:
---------
IDSTADE
STADENAME


and a table many to many to know who played with who:

GAMES:
--------
IDTEAM1
IDTEAM@
IDSTADE


now I want to have a query that tells me who played in the stades 1,43,6,5 (for example) as TEAM1. How can I do that?

Thank you"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-09-14 : 09:40:22
Read about JOINs in sql server help file

Also Learn SQL

http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-09-14 : 09:41:29
STADES IN (1,43,6,5)????

Read the hint link in my sig and post what it asks for



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page
   

- Advertisement -