我的具体语法如下:(sql2000中)
select car_NO from table_car where car_NO not in
( select car_NO from table_carout where car_state=1 and
out_datetime>=
(
select table_out.out_date +' '+ table_out.out_outtime as ff from table_out inner join table_carout on table_out.out_NO=table_carout.out_NO
)
and
out_datetime<=(********)
)