Board index » delphi » SQL select question: self join?
ae...@aelhk.com (aelhk)
![]() Delphi Developer |
Wed, 18 Jun 1902 08:00:00 GMT
SQL select question: self join?I got a table like this Name Item1 Item2 Item3 Qty I want to list the total of items for a QuickReport's TQuery. SELECT ITEM1,SUM(QTY) FROM TABLE1 It is very strange the result table contains one blank entry. What is the proper statement to do the above SELECT ? Thanks. |