表t1
----------
id name
----------------
1 ssss
2 dddd
....
select name as n1,name as n2 from t1 where n1=(select ....) ,n2=(select ...)怎样将name字段用参数表示呢?
----------
id name
----------------
1 ssss
2 dddd
....
select name as n1,name as n2 from t1 where n1=(select ....) ,n2=(select ...)怎样将name字段用参数表示呢?
......
from t1
可能是我方法不对,呵呵,没有这种把别名当作字段来操作的吗?
select * from T1 a where exists(select 1 from t1 where Name='?') and exists
(select 1 from t1 where Name='??')
(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