请教如何去除此数据

[xiaohuajx]

SQL:
select * from (select insurance_code,a.city_code,c.city_id,
insurance_ratio, agent_ratio, auib_ratio, ts_ratio, biitco_ratio from cm_unit_ratio a
, ms_city c )a where (city_code=city_id OR city_code=999 ) AND city_id<>999

结果:
ROW INSURANCE_CODE CITY_CODE CITY_ID INSURANCE_RATIO AGENT_RATIO AUIB_RATIO TS_RATIO BIITCO_RATIO
1 01 1 1 0.40000 0.45000 0.05000 0.05000 0.05000
2 01 999 1 0.50000 0.35000 0.05000 0.05000 0.05000
3 01 999 2 0.50000 0.35000 0.05000 0.05000 0.05000
4 01 999 3 0.50000 0.35000 0.05000 0.05000 0.05000
5 01 999 4 0.50000 0.35000 0.05000 0.05000 0.05000
6 01 999 5 0.50000 0.35000 0.05000 0.05000 0.05000
7 01 999 6 0.50000 0.35000 0.05000 0.05000 0.05000
8 01 2 2 0.55000 0.40000 0.05000 0.05000 0.05000


请问如何在SQL中剔除 2,3行数据.谢谢

[fjmingyang]

只能对原始表进行删除，不能对join出来的数据进行删除

[fjmingyang]

更正下：上面的说法不准确，关于对表连接的DML比较麻烦，你可以参考下：http://www.itpub.net/45822,2.html