Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 3 table SQL Join Query
- Three tables, GameSched, UmpSched, GameLoc.PK stands for Primary Key, FK is Foreign Key.GameSched has Day,Date,Time,Home,Away,Location,IDPKGameLoc has Name,Url,IDPKUmpSched has First,Second,Third,Plate,GameNoFK,IDPKThe following query retrieves an Empty Set. However, I can query GameSched with GameLoc or GameSched with UmpSched and retrieve the appropriate records. I know I need a...
- Tags: diamond, dryflies, GameLoc, GameSched, GameSched INNER JOIN GameLoc, GameSched.ID, GameSched.Location, programming, SQL, UmpSched, UmpSched.GameNo
- Q&A 2006-01-25
- << Previous
- page 1 of 1
- Next >>