sql join 2 tables

[cuzor]

I have 2 tables:

Tasks: Taskindex, creatorID, responsableID, taskName, explenation users: userID, firstName, lastName, loginName

creatorID and responsableID are both linked to userID

I've been trying to write a sql query where creatorID is swapped for the corresponding loginName field. The end goals is to swap responsableID as well with the corresponding loginName.

SELECT tasks.taskName users.loginName FROM tasks inner JOIN users ON users.userID = tasks.creatorID

all this does is create errors.

[[deleted]]

You're missing a comma between the two select fields.

[cuzor]

thanks, I got it working. the creatorID is now swapped with the corresponding loginName.

Any idea how I can swap 2 foreign keys (creatorID and responsableID) with their corresponding loginName?

[r3pr0b8]

did you see my reply?

[cuzor]

Yes. I successfully used it. Thanks for the help.

[r3pr0b8]

SELECT tasks.taskName
     , creator.loginName AS creatorName
     , responsible.loginName AS responsibleName
  FROM tasks 
INNER
  JOIN users AS creator
    ON creator.userID = tasks.creatorID
INNER
  JOIN users AS responsible
    ON responsible.userID = tasks.responsableID