This works fine as you have it in MS SQL Server. David Cornelius Cornelius Concepts, Inc. http://corneliusconcepts.com <http://corneliusconcepts.com/> Software Development, Databases, Websites _____
From: prof. Stevan Djuranovic [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 4:28 PM To: [email protected] Subject: [delphi-en] sql joining two columns in one Delphi 5 and SQL. This is a problem... ------------------------------- SELECT (FirstColumn + ' ' + SecondColumn), SUM (ThirdColumn) FROM TableName GROUP BY (FirstColumn + ' ' + SecondColumn) ORDER BY (FirstColumn + ' ' + SecondColumn) Error: Capability not supported. -------------------------------- So, I need to join two columns in one and display results. Everything works just fine. But, when I put third column (SUM...) it says I need to use GROUP BY... I need to group by (FirstColumn + SecondColumn) or just by FirstColumn. That not working. What should I do? Is there a solution? Thx. --------------------------------- How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/delphi-en/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
