Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2004
    Posts
    31

    Unanswered: [solved] advanced query... can't get a grip.

    [SOLVED... Never mind]

    Hi all!

    I'm having a bit of a problem putting together a select-statement.

    Here's the tables

    [tblPlayer]
    playerid | playerpos
    0012 | G
    0013 | F
    ...

    [tblPMP]
    pmpid | playerid | ... | ... | ...
    0234 | 0013 | ...
    0426 | 0012

    [tblBench]
    teamid | pmpid
    1423 | 0234
    1735 | 0426

    I need to form a select statement that selects teamid & pmpid from [tblBench] and also playerpos from [tblPlayer]

    I've torn my hair on thisone already... And it probably isn't that difficult...

    thanks guys
    Last edited by Zcumbag; 10-31-04 at 21:37.

Posting Permissions

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