求教高手一个SQL语句

[adw3scgw432sfw]

select * from ABC where [name]='高' 这个 SQL语句单独执行可以执行。但是我想把它放到另一个SQL语句的 and后面执行，比如把它写成 select * from tina where [name]='123' and (select * from list where [name]='高') 为什么就执行不了了呢，显示 ：
当没有用 EXISTS 引入子查询时，在选择列表中只能指定一个表达式。
请问这是为什么？

[OracleRoob]

--如果把(select * from list where [name]='高')作为条件
select * from tina where [name]='123'
and exists(select * from list where [name]='高')


--如果把(select * from list where [name]='高')作为数据集与(select * from tina where [name]='123' )合并
select * from tina where [name]='123'
union all
select * from list where [name]='高'

[xq02]

select * from tina where [name]='123' and exists(select * from list where [name]='高')

[hyrongg]

select * from tina where [name]='123'
union all
select * from list where [name]='高'

[数字化从业者老高]

select * from tina where [name]='123'
union all
select * from list where [name]='高'
这个应该是楼主想要的，我想。

[FCU]

select * from tina where [name]='123'
union all
select * from list where [name]='高'
---------------

嘻嘻.............

[十一月猪]

union all
or
union

[Updater8]

高,实在是高.

[aniude]

AND
是用来连接两个布尔表达式的
UNION
将两个或更多查询的结果组合为单个结果集

[Well]

用union all

[regithanhu]

wangtiecheng(不知不为过，不学就是错！)
顶

[sunskyfeng]

UP