yes that would make sense, but there is no other table.... there is only one table.
-----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 03 February 2003 15:25 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL Fuzz > 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..... SELECT tbl.Name, tbl.FileID, tbl.SharerID, otherTbl.Name FROM ( SELECT Name, FileID, SharerID FROM MyTable) as tbl INNER JOIN Othertbl ON tbl.SharerID = Othertbl.SharerID Make Sense? Paul -- ** 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] -- ** 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]
