Find a SQL statement

hdifilwyw

There are two tables, one is the article table and one is the user table
Article table
id title user1 user2
1 Article 1 1 2

user table
id username
 1 sheet three
 2 Lee Si

Now to get the record as
1 Article 1 Zhang San Li Si
How to construct SQL statements

hdifilwyw

I asked if I could use subqueries to achieve this SQL statement.

fanfan1980

create table A (id int, title nvarchar (10), user1 int, user2 int)
insert A select 1, 'Article 1', 1, 2

create table B (id int, username nvarchar (10))
insert B select 1, '张三'
union all select 2, '李四'

select A.id, A.title, tmpA.username as user1, tmpB.username as user2 from A
left join B as tmpA on A.user1 = tmpA.id
left join B as tmpB on A.user2 = tmpB.id
--result
id title user1 user2
----------- ---------- ---------- ----------
1 Article 1 Zhang San Li Si

(1 row (s) affected)

fanfan1980

Is it OK to connect?

72251845

Select
    wzb.id, wzb.title, yh1.username, yh2.username
From article list wzb
Inner Join user table yh1 on wzb.user1 = yh1.id
Inner Join user table yh2 on wzb.user2 = yh2.id