Hi all, It seems like my last message didn't came through, so here it is again:
It's been a while since I've done any SQL work, so I need some help/pointers for the following problem: I have 1 table with users with a ID, username, insertbyuserIDFK, editbyuserIDFK and deletedbyuserIDFK (and some more irrelevant columns). The query needs to get the users with the usernames of the user that inserted, edited and if filled in, deleted the user entry. Any help on this is appreciated! Thanks, Michael ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3155 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
