Mel,
PMFJI
Select * is considered great for a quick and dirty SQL however it leads to troubles. The maintainable way is to name each field required. You have no guarentee what order the fields will be in, so group by 1 or order by 1 are certain to give you problems in the future. If you add a field to the table then all of your select * views will bomb.
Regards
>>Here is the thread of interest GROUP BY 1 no longer works Thread #
750415 Message #
750415<
>
>Thank you Nadya.
>
>I see what I am dealing with now - and I will definately not be using Group By 1 in this situation.
>
>Your FAQ was also helpful.
>
>Mel Cummings