>Hi All,
> I am using the simple select statement and getting the following error:
>
>Error is SQL expression is to complex
>
>my select is
>
>SELECT Regno from Test group by Regno order by Regno ;
>Where Regno not in(12,41,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,7012,59,60,61,62,63,64,65,66,67)
>
>Any Ideas?
You might put the excluded values into a table, and then:
select ...
where regno not in (select regno from ExcludedValues)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
