Mysql query to get inserted user name and updated user name with select query? [duplicate]

Question

I have two tables products and users with fields,

Products

id
name
insertedUserID
ipdatedUserID

Users

id
name

I am trying to get the the product details with the data,

ProductID
ProductName
InsertedUser
UpdatedUser

For this I am using this mysql query,

SELECT Products.id as ProductID,Products.name as ProductName, Users.name as InsertedUser 
LEFT JOIN Users ON Products.insertedUserID = Users.id

This query is working only for Inserted user only. How can I get updated user with this query?

Shafiqul Islam · Accepted Answer · 2017-11-01 06:34:00Z

0

I am not sure you want to get both data or and condition so . if you want to both condition data then use union all

SELECT Products.id as ProductID,Products.name as ProductName, Users.name as InsertedUser 
LEFT JOIN Users ON Products.insertedUserID = Users.id

union all 
SELECT Products.id as ProductID,Products.name as ProductName, Users.name as InsertedUser 
LEFT JOIN Users ON Products.ipdatedUserID = Users.id

or if you want to only single condition then

SELECT Products.id as ProductID,Products.name as ProductName, Users.name as InsertedUser 
    LEFT JOIN Users ON Products.insertedUserID = Users.id and Products.ipdatedUserID = Users.id

hope it will help you

answered Nov 1, 2017 at 6:34

Shafiqul Islam

5,6852 gold badges36 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Wodin Over a year ago

I suspect what is needed here: LEFT JOIN Users ON Products.insertedUserID = Users.id and Products.ipdatedUserID = Users.id is "OR", not "and".

Collectives™ on Stack Overflow

Mysql query to get inserted user name and updated user name with select query? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related