一个比较复杂的搜索，请给出SQL语句，谢谢了！！

[哈哈哈哈]

select * from table where ndate='2003' or ndate='2000'

但是，如果2003和2000同时有某个字段时，我只想让它列出ndate=2000的那条信息该怎么办，SQL语句改怎么写？？？

谢谢！

[weixxxp]

select * from table where (ndate='2003' and field not in (select distinct a.field from table a where ndate='2000')) or ndate='2000'

[CrazyFor]

select * from table where ndate='2000'
是这个意思吗？

[yelook]

select a.* from (select * from table where ndate='2003' or ndate='2000') a inner join (select min(ndate),field from table where ndate='2003' or ndate='2000' group by field) b on a.filed=b.filed

[yelook]

select a.* from (select * from table where ndate='2003' or ndate='2000') a inner join (select min(ndate),field from table where ndate='2003' or ndate='2000' group by field) b on a.field=b.field and a.ndate=b.ndate