Ahh, sorry about that. I am not very good with MySql so I am afraid I can't be of more assistance.
Bruce Rick Faircloth wrote: > Hi, Bruce and thanks for the reply. > > TOP (1) isn't working. From what I can tell, that's an MSSQL > function and MySQL (sorry, should have specified db) doesn't use it. > MySQL uses Limit 1 for that functionality, but in this case, I don't > want to get just the first community, but every community, but only the > first photo in the db for each community. > > I've tried using join, but haven't hit upon the correct syntax, yet. > > Any other ideas? > > Rick > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
