Kim Kohen wrote: Comparing > Page Ad_num status stories > 1 4312-T1308 Ad Complete 1-marchingband-A33 Placed > 1 4312-T1308 Ad Complete 1-jobs-T33 > Placed 1 4312-T1308 Ad Complete 1-illegalbuild-A32 > Placed 1 4312-T1308 Ad Complete 1-haldonstfesty-T33 > Placed 1 4312-T1308 Ad Complete 1-jobs-T33 > Corrected 1 4312-T1308 Ad Complete 1-car crash-T33 > Placed to > 1 4312-T1308 Ad Complete > 1 1-marchingband-A33 Placed > 1 1-jobs-T33 Placed > 1 1-jobs-T33 Corrected > 1 1-illegalbuild-A32 Placed > 1 1-haldonstfesty-T33 Placed > 1 1-car crash-T33 Placed
it feels like you want your results grouped by Ad_num. http://www.mysql.com/doc/en/GROUP-BY-Functions.html Just my 2 cents, HansH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
