Results 1 to 2 of 2

Thread: recordset/loop/madness

  1. #1
    Join Date
    Dec 1969

    Default recordset/loop/madness

    I&#039;m sure this is a lot easier than it seems.<BR><BR>I&#039;ve got two tables: Users and Action<BR><BR>users includes a userID and a userName field<BR><BR>Action includes Action and userID fields (so I know which user performs the action)<BR><BR>Now, I&#039;m displaying the data from the Action table in an html table using a loop. No problem there, but along with the action, I want to display the userName not the userID. So my question is how can I replace the userID value with it&#039;s corresponding username?

  2. #2
    Join Date
    Dec 1969

    Default RE: recordset/loop/madness

    SELECT * FROM Users INNER JOIN Action ON Users.userID=Action.userID WHERE blah blah blah<BR><BR>does that help?

Posting Permissions

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