数据库中,同一表中的两个字段拼接到一起,做为查询条件的查询
SELECT *
FROM * jd
where 1=1 and jd.name ='要情'
and (convert(varchar,jd.year)+convert(varchar,jd.issue))>= 20062
and (convert(varchar,jd.year)+convert(varchar,jd.issue))<= 20074
order by jd.year desc ,jd.issue desc
数据库中,同一表中的两个字段拼接到一起,做为查询条件的查询
SELECT *
FROM * jd
where 1=1 and jd.name ='要情'
and (convert(varchar,jd.year)+convert(varchar,jd.issue))>= 20062
and (convert(varchar,jd.year)+convert(varchar,jd.issue))<= 20074
order by jd.year desc ,jd.issue desc