+++
1、select * from linshi4 as tableA where name='梁朝伟'
union
select * from linshi4 as tableB where tableB.name != tableA.name
2、select * from linshi4 as tableA where name='梁朝伟'
union
select * from linshi4 as tableB where tableB.name not in tableA.name
+++
两个写法都报错。
我的想法是 在tableB的操作中拿到tableA的参数(两者最好是同级关系)
请问要怎么实现?
求代码
+++
更新: