select * from source cross join ( select * from image union all select * from audio union all select * from video ) a
改成这样OK了,谢谢!select * from source as A cross join ( select * from image union all select * from audio union all select * from video )as B where A.id=B.sid
2.这里是MSSQL版
3.需要测试数据和想要的结果
4.有可能
select * from source cross join
(
select * from image
union all
select * from audio
union all
select * from video
) a
改成这样OK了,谢谢!select * from source as A cross join
(
select * from image
union all
select * from audio
union all
select * from video
)as B
where A.id=B.sid