select U1.[Name] as USer1Name
,U2.[Name] as USer2Name
,Content.Content
from Content
join Users U1 on Content.User1ID=U1.[ID]
join Users U2 on Content.User2ID=U2.[ID]
,U2.[Name] as USer2Name
,Content.Content
from Content
join Users U1 on Content.User1ID=U1.[ID]
join Users U2 on Content.User2ID=U2.[ID]
Select
B.Name As USer1Name,
C.Name As USer2Name,
Content
from Content A
Left Join Users B On A.User1ID=B.ID
Left Join Users C On A.User2ID=C.ID