> 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]
