By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,694 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,694 IT Pros & Developers. It's quick & easy.

Ntext field vs Group By

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.