SQL Statement...

Results 1 to 2 of 2

Thread: SQL Statement...

  1. #1
    Join Date
    Dec 1969

    Default SQL Statement...

    I have three tables:<BR><BR>Pick, Position, and Team.<BR><BR>Using rsPicks.Contestant and the rs.Pickposition I am able to pull out the Contestants personal picks for each position. Now I would like to write a SQL statement that can pull the team for each contestants unique player???

  2. #2
    Join Date
    Dec 1969

    Default If you have two recordsets...

    ...you are doing it wrong already.<BR><BR>Show your table layouts, at least the important fields that link one table to another.<BR><BR>For example, I presume that you have<BR><BR>Team: Table<BR>teamID : primary key<BR>teamName : text<BR>...<BR><BR>Table: Position<BR>posID : primary key<BR>teamID : foreign key to Team table<BR>posName : text <BR>...<BR><BR>Or *something* along those lines. Show us all that kind of stuff (no need for the detail stuff...just the major fields of each table is enough).<BR><BR>Then we can do it all in one SQL query and one recordset.<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts