同一表中，查询时怎么将字段区分

[Maxdell]

表t1
－－－－－－－－－－
id name
----------------
1 ssss
2 dddd
....


select name as n1,name as n2 from t1 where n1=(select ....) ,n2=(select ...)

怎样将name字段用参数表示呢？

[Maxdell]

select x.name,y.name from t1 as x,t1 as y where x.name ... and y.name ...

我想把 x.name ，y.name 当作后面 where 操作的参数。
可能是我方法不对，呵呵，没有这种把别名当作字段来操作的吗？

[中国风]

可以,别名x\y没有连接条件为布尔表达式?

[中国风]

或:
select * from T1  a where exists(select 1 from t1 where Name='?') and exists
(select 1 from t1 where Name='??')

[中国风]

select * from T1  a where exists(select 1 from t1 where ID=a.ID and Name='?') and exists
(select 1 from t1 where ID=a.ID and Name='??')--应有一个条件ID与外表连

----------------
if exists(select 1 from T1 where Name='?') and exists(select 1 from T1 where Name='??')
select * from T1

[dawugui]

select name as n1,name as n2 from t1 where n1 in (select ....) and n2 in (select ...)

[Limpire]

select (name as n1 from t1 where ...), (name as n2 from t1 where ...)

[-狙击手-]

select id,case when name ... then name end as n1,
......
from t1

[Limpire]

不明需求，看句型是不可能实现的。