Advertisement

10.09.2008 at 06:50AM PDT, ID: 23800803 | Points: 500
[x]
Attachment Details

neee to modify a query in sql 2000 query analyser to return names instead of ids

Asked by blossompark in SQL Query Syntax, MS SQL Server

Tags: , ,

Hi,
I need to adjust the sql query (see  attachment)  in query analyser to return the first and last names of the log agents.
The log agents column  references the ctct table.
The ctct table holds names for both Customers and Log agents.
Thanks.
Start Free Trial
Attachments:
 
query analyser grab
 
[+][-]10.09.2008 at 07:02AM PDT, ID: 22678457

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 07:03AM PDT, ID: 22678472

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 07:22AM PDT, ID: 22678661

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 07:23AM PDT, ID: 22678668

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.14.2008 at 04:21PM PST, ID: 22965062

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628