NOOO! This is COMPLETELY different query.
In your sample result set will contain less rows than for original query. Try to investigate why.
>Wouldn't this select do the same thing, only faster:
>select * from view1 where year = "2001" and acc_field like "5%"
>
>and if exact is set off, like "5%" could be replaced with = "5".
>If you need distinct before the *, that would mean that you must have entire rows duplicated, which would signal a db design flaw (my opinion).
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.