Here's one I cant seem to get at the mo.. I have a result (SQL Server) which gets me back data all fine and dandy... it returns the following [pseudo] fields...
Name FileID SharerID A sample set of data could be : Name FileID SharerID ------- ------- ------------ Foo 1 2 Boo 2 4 Goo 3 1 Choo 4 3 What I need to do is query the table above BUT get the 'Name' which corresponds to the SharerID itself..in one query..... Make sense?! :-) Ta Neil -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
