Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mydrive22

    SQL Statement help

    Thans for your help. I couldnt quite get it to work so I used some nested Select statements SELECT GAME.GAME_ID ,GAME.DATE ,GAME.GAME_STATUS ,GAME.HOME_TEAM_ID ,(SELECT TEAMs.TEAM_NAME FROM TEAMs WHERE GAME.HOME_TEAM_ID = TEAMs.TEAM_ID) AS HOME_TEAM...
  2. mydrive22

    SQL Statement help

    This is probably an easy one. I am fairly new to this. Here is what I have I am working with three tables right now a Teams table which lists Team names and their ID's In another table I have games listed with Visiting teams and Home teams IDs, as well gameDate, Status, etc. I am working on...

Part and Inventory Search

Back
Top