>
>Select parent.* ;
> from parent,child ;
> where parent.locindex=child.locindex ;
> group by child.locindex ;
> having count(*)>1
>
>If you need in child data you can select into cursor and then join to child table without grouping.

I do need child data and parent data, what I want is an
SQL select statement that will out put for only those
parents that have more than one child, and I want to see data for
both parent and child.

Thanks for your help thus far...I would like to get it down to
one select statement.