At 16:27 -0700 9/10/04, bruce wrote:
hi...
if i do this...
select
h1.itemID as hitem,
h1.process as process,
h1.status as status,
h1.tblType as tbl,
h1.date as date
from historyTBL as h1
where (h1.tblType = '3' or h1.tblType = '4');
i get a results table with ~5000 rows...
if i add the 'group by' sql,
select
h1.itemID as hitem,
h1.process as process,
h1.status as status,
h1.tblType as tbl,
h1.date as date
from historyTBL as h1
where (h1.tblType = '3' or h1.tblType = '4')
group by tblType; <<<<<<<<<<<<<<<<
i get a single line for each tblType...
i was under the impression that i should get the same number of rows
returned, but that they would be grouped together.....
can someone provide an explanation as to how this should work, and what's
going on????
If you use GROUP BY with selecting the value of any aggregate functions,
you achieve the same effect as SELECT DISTINCT.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
