Ntext field vs Group By

[A_PK]

I got one field, NOTE, its type is Ntext field.
I have problem when query the statement using GROUP BY, could some pls
kindly guide me.

please found the sql query below...

SELECT tblParent.indexno, tblParent.custno,
tblParent.compname, tblParent.tt, tblParent.ordnotes
FROM tblParent INNER JOIN
tblChild ON tblParent.tid = tblChild.tid
WHERE (tblchild.prodid BETWEEN N'1' AND N'z')
GROUP BY tblParent.indexno, tblParent.custno,
tblParent.compname, tblParent.tt !!!!!!!!! error here...i can not put
tblParent.ordnotes, because is is ntext field...no allow to sort or
compare.....

So, if I want to show all those field, but still using GROUP BY, cos I dun
want to dunplicate all the prodid...

Thank you very much

[Ken Tucker [MVP]]

Hi,

The fields listed in the select statement are return with the
query. You can groupby only one field and still see all the fields
specified in the select statement

Ken
----------------------
" A_PK" <pk***@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
I got one field, NOTE, its type is Ntext field.
I have problem when query the statement using GROUP BY, could some pls
kindly guide me.

please found the sql query below...

SELECT tblParent.indexno, tblParent.custno,
tblParent.compname, tblParent.tt, tblParent.ordnotes
FROM tblParent INNER JOIN
tblChild ON tblParent.tid = tblChild.tid
WHERE (tblchild.prodid BETWEEN N'1' AND N'z')
GROUP BY tblParent.indexno, tblParent.custno,
tblParent.compname, tblParent.tt !!!!!!!!! error here...i can not put
tblParent.ordnotes, because is is ntext field...no allow to sort or
compare.....

So, if I want to show all those field, but still using GROUP BY, cos I dun
want to dunplicate all the prodid...

Thank you very much