贤人必须成人,成人才能达己.

共同进步

  :: :: 博问 :: 闪存 :: 新随笔 :: :: :: 管理 ::
select buslicense  from bus a
where
not exists
 (select 1 from TkSerialSch b
  where b.s_drvTime >'2007-12-21'
  and a.buslicense=buslicense
 )


select buslicense  from bus
where
  buslicense
not in
 (select distinct b.buslicense from TkSerialSch b
  where b.s_drvTime >'2007-12-21'
  and b.buslicense  is not null
 )
posted on 2007-12-18 19:08  adi  阅读(191)  评论(0编辑  收藏  举报