Post the query you use to get the actual query and the name of the table where SharerName can be found.
----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 3:15 PM Subject: RE: [ cf-dev ] SQL Fuzz > 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] > -- ** 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]
