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 |
|
charanya
Starting Member
2 Posts |
 Posted - 2012-09-06 : 04:27:44
|
| Show names of all non-German players who scored a goal in matches against Germany. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-09-06 : 04:38:41
|
Show tables, columns and datatypes including sample data and wanted result to get an answer.
Too old to Rock'n'Roll too young to die. |
 |
|
|
bpfrenchak
Starting Member
1 Post |
Posted - 2012-11-05 : 15:30:42
|
| SELECT player FROM game JOIN goal ON matchid = id WHERE team1='GER'and teamid != 'ger'unionSELECT player FROM game JOIN goal ON matchid = id WHERE team2='GER'and teamid != 'GER' |
|
|
|
|
|
|
answer for sqlzoo.net join with two tables