--这样? select pop_a from [uesr] a,[section] b where a.name=b.name and b.[year]=@year and b.quarter=@quar
select *from section s,user u where s.name = u.name and s.year=? and quarter=? and u.name=? and u.pop_a = ?
不是 是查询select × from section where year=year and quarter=quar and 这个地方的name等于user表里面pop_a为变量s的名字 这个name可能有好几个
select * from user u left join session s on s.name = u.name where s.year=? and quarter=? and u.name=? and u.pop_a = ?
select distinct pop_a from [uesr] a,[section] b where a.name=b.name and b.[year]=@year and b.quarter=@quar ?
select * from section where year=year and quarter=quar and name in ( select name from user where pop_a =? )
select * from section where [year]=year and quarter=quar and name in [code=SQL](select [name] from user where pop_a=s)[/code]
sql="select * from section where and year='"&yeare&"' and quarter = '"&quarter&"' and name in (select name from [user] where section_pop ='"&sorta&") order by desc"帮我看看有没写错啊
select name from section where year=@year and quarter=@quarter and name exists(select name from user where pop_a =@s)这样?
select name from section s where year=@year and quarter=@quarter and exists(select name from user where pop_a =@s and s.name=name) 这样就对;
sql="select * from section where --and--这个AND去掉 year='"&yeare&"' and quarter = '"&quarter&"' and name in (select name from [user] where section_pop ='"&sorta&") order by desc"
--这样?
select pop_a from [uesr] a,[section] b
where a.name=b.name and b.[year]=@year and b.quarter=@quar
quarter=? and u.name=? and u.pop_a = ?
quarter=? and u.name=? and u.pop_a = ?
where a.name=b.name and b.[year]=@year and b.quarter=@quar ?
(
select name from user where pop_a =?
)
这样就对;
--and--这个AND去掉
year='"&yeare&"' and quarter = '"&quarter&"' and name in (select name from [user] where section_pop ='"&sorta&") order by desc"