What I need is this : Actual Query =========
Name FileID SharerID ------- ------- ------------ Foo 1 2 Boo 2 4 Goo 3 1 Choo 4 3 Query wanted : ========== Name FileID SharerName ------- ------- ------------ Foo 1 Boo Boo 2 Choo Goo 3 Foo Choo 4 Goo -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 03 February 2003 15:12 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL Fuzz > Make sense?! :-) not really.... are you saying you have a recordset returned with those fields, and you just want the name field? then a) use that recordset and just make mention of the myQuery.name[row] variable OR b) only select 'name' in the query c) only select name from the subquery, the subquery being your main SQL suery d) create a view from the main query and then select the name from it. Am I understanding? Rich > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: 03 February 2003 15:06 > To: '[EMAIL PROTECTED]' > Subject: [ 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..... > > 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] > -- ** 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]
