group by issue...??

[bruce]

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????

thanks....

-bruce