Oh yah, and if you're joining a bunch of tables, using aliases is a nice thing. It's another one that's not really a dummy flag, but I do try to pound it into Kevin's head. (No, Kevin, you don't have to write out is_masterrecord.masterrecorid....you can alias it and write m.masterrecordid.) ;)
-d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm