如何在这个语句中添加一些语句，查找出Datetime小于1998年的数据：select gl1.userid,gl1.name,gl2.datetime,gl2.section,gl2.wage from gl1,gl2 where gl1.userid=gl2.userid and gl2.wage>800;

section:部门
wage：工资

select gl1.userid,gl1.name,gl2.datetime,gl2.section,gl2.wage from gl1 inner join gl2 on gl1.userid=gl2.userid where gl2.wage>800 and Datetime<1998
不知道这样是不是你要的东西哦?本人没去测试

select gl1.userid,gl1.name,gl2.datetime,gl2.section,gl2.wage from gl1 inner join gl2 on gl1.userid=gl2.userid where gl2.wage>800
and gl2.datetime<1998

select gl1.userid,gl1.name,gl2.datetime,gl2.section,gl2.wage from gl1 inner join gl2 on gl1.userid=gl2.userid where gl2.wage>800
and gl2.datetime<‘1998-01-01’

这个  要分  Datetime  是什么数据格式   时间格式  字符串格式  整形格式  不一样的