有关于SQL语句的问题。 (50分)

LINE_CODE CHG_CODE TRUCK_CODE DERIVER_CODE 下面还有字段不写了。
a ad aaa ALL
a ad ALL ALL
ALL ad aaa b
a qqq aaa b
a qqq ALL ALL
ALL qqq aaa ALL
ALL WWW ALL ALL

当 line_code等于 a ,truck_code等于 aaa ,驾驶员等于 b 时。
得到的记录为
LINE_CODE CHG_CODE TRUCK_CODE DERIVER_CODE
a ad aaa ALL
ALL WWW ALL ALL
a qqq aaa b
就是要按 chg_code 分类。 但是当chg_code有多条记录对应时，就要
先取 line_code 等于 a 的，然后再是 truck_code 为 'aaa'，最后DRIBER_CODE为 b的


这个问题也可以是
{ a ad aaa ALL
a ad ALL ALL
ALL ad aaa b
} 取出
a ad aaa ALL

我想应答，可不明白你要问的问题是什么？[]

是呀，看了半天不知道问题。

我也不明白，呵呵~！

比较麻烦的方法是，
把每一步得出的结果集放入一个临时表（temptable）中
1、select * into temptable from tablename where
(LINE_CODE='a') and (TRUCK_CODE='aaa') and (DERIVER_CODE='b')
2、insert into temptable
select * from tablename where
(LINE_CODE='a') and (TRUCK_CODE='aaa') and (DERIVER_CODE='All') and
(CHG_CODE not in (select CHG_CODE from temptable))
3、insert into temptable
select * from tablename where
(LINE_CODE='a') and (TRUCK_CODE='All') and
(CHG_CODE not in (select CHG_CODE from temptable))
4、insert into temptable
select * from tablename where
(LINE_CODE='All') and (CHG_CODE not in (select CHG_CODE from temptable))