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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]