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! Messengers low PC-to-Phone call rates.
[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/
