~~~~~~~~~~~~~~~~~~~~~~~~~~ Why not do: SELECT bulletins.bulletinID, bulletins.heading, bulletins.intro, bulletins.createDate, bulletins.activated, COUNT(bulletinNews.bulletinID) AS numItems FROM bulletins, bulletinNews WHERE bulletinNews.bulletinID = bulletins.bulletinID GROUP BY bulletins.bulletinID, bulletins.heading, bulletins.intro, bulletins.createDate, bulletins.activated ORDER BY COUNT(bulletinNews.bulletinID) ~~~~~~~~~~~~~~~~~~~~~~~~~~
There may be bulletins with no news items assigned to them. I guess I could put an OUTER JOIN in there to get them as well. Thanks for the advice... - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
