Oh Snap! Misha, I think that does the trick! Thanks so much - that is really great! That helps out a lot - I already spent a lot of my morning on that before I decided to post here... I have the hardest time getting my mind around those table joins... Thanks again!
Now if I can get the dynamic table sorting figured out I should be all set! Thanks! - Nick -----Original Message----- From: Misha Mishyn [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 3:14 PM To: CF-Newbie Subject: Re: Query Help Hi Nick, Im not a big MySQL DB guy, but meanwhile you can try this and see if it works for you: ****************************** SELECT DISTINCT EmailGroupLink.MGID ,EmailGroup.MGTitle ,Account_Files.FileName ,Account_Files.UniqDirectory ,Account_Files.Description ,Account_Files.PostedDate ,Account_Files.AFID ,Account_Files.Active FROM EmailGroupLink INNER JOIN EmailGroup ON EmailGroupLink.MGID = EmailGroup.MGID INNER JOIN Account_FileLinks ON Account_FileLinks.MGID = EmailGroupLink.MGID LEFT JOIN Account_Files ON Account_Files.AFID = Account_FileLinks.AFID WHERE EmailGroupLink.ESID = <cfqueryparam cfsqltype="cf_sql_integer" value="#SESSION.Auth.ESID#"> AND Account_Files.Active = 1 ORDER BY Account_Files.FileName ****************************** Regards, Misha ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3920 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
