MySQL query with two identicals fields

Question

the DB looks like this, and I need a query to get each stat with the idstat, the user downloader, and the user creator. Without adding a line "user_creator" in the stat table. I should be able to get the user creator with stat.contentidcontent > content.iduser but I can't reach it, I always get the iduser_downloader in the iduser_creator column.

Thanks!

Just join the three tables. Please show us your query and we'll tell you what's wrong about it. If you want both users, you'll have to join the user table twice. — Thorsten Kettner
– Thorsten Kettner, Commented Aug 31, 2020 at 8:35

forpas · Accepted Answer · 2020-08-31 08:58:30Z

2

You must join 2 copies of user to get the downloader and the creator:

select s.idstad,
       ud.iduser downloader_id, ud.name downloader_name,
       uc.iduser creator_id, uc.name creator_name
from stat s
inner join user ud on ud.iduser = s.user_iduserdownloader
inner join content c on c.idcontent = s.content_idcontent
inner join user uc on uc.iduser = c.user_iduser_creator

edited Aug 31, 2020 at 8:58

answered Aug 31, 2020 at 8:41

forpas

165k10 gold badges51 silver badges85 bronze badges

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

1 Comment

L01C Over a year ago

Thanks it works. There a just a missing coma after the first line ;) .

Collectives™ on Stack Overflow

MySQL query with two identicals fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related