22,207
社区成员
发帖
与我相关
我的任务
分享
select * from UT_PROGRAM u1
full join (select * from UT_PROGRAM where userid=4 ) u2 on u2.ProgramID=u1.ProgramID
where u1.userid =50437
SELECT *
FROM ( SELECT *
FROM UT_PROGRAM
WHERE userid = 50437
) u1
INNER JOIN ( SELECT *
FROM UT_PROGRAM
WHERE userid = 4
) u2 ON u2.ProgramID = u1.ProgramID
select *
from (select * from UT_PROGRAM u1 where userid =50437) as u1
full join (select * from UT_PROGRAM where userid=4 ) u2 on u2.ProgramID=u1.ProgramID