SQL*Plus

From: <mitchell7468_at_my-deja.com>
Date: Tue, 01 Jun 1999 19:17:43 GMT
Message-ID: <7j1bkn$6j2$1@nnrp2.deja.com>

I was wondering if anyone could tell me why the query below doesn't delimit the agent_name and manager_name. The agent_name and manager_name appear in the same table without a label.

Any help would be appreciated.

spool l:\share\bmso\paul\owner.txt
set pagesize 0
set colsep '!'
SELECT customer_acct_id, "AL_SALES_HIERARCHY"."HIERARCHY_DSC",

"AGENT_A"."SALES_OFFICE_NM",

			' ' as division,
         NVL("AGENT_A"."LAST_NM", '') || ' ' || NVL
("AGENT_A"."FIRST_NM", '') as agent_name,
         NVL("AGENT_B"."LAST_NM", '') || ' ' || NVL
("AGENT_B"."FIRST_NM", '') as manager_name
	FROM "AGENT" "AGENT_A",
			"SPRT_AGENT_CUSTOMER_XREF",


         "AL_AGENT_SALES_HIERARCHY",


         "AL_SALES_HIERARCHY",


         "AGENT" "AGENT_B"

Thanks
PM

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 01 1999 - 14:17:43 CDT