At 01:20 AM 11/29/01 -0500, you wrote:
>Yeah, it's easy, but inefficient, to do with CF but how can I make SQL do
>this for me (esp with the {null})? It's gonna turn out to be something easy
>that I've seen before, but I haven't had to write something like this for
>like a year and now I'm drawing a one in the morning blank. Is it a GROUP BY
>thing? or a sub-query thing?
Use the group by command.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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
