Re: Formatting columns in a mixed query

"Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote in <9c4075$4qt$1_at_news.liv.ac.uk>:
<snip>
>
>: Thanks for the advice - I've tried this but I still get the same
>: result

 only
>: minus the ",". eg:
 

>: AFF TOTAL_RECORDS ADD_RECORDS UPDATE_RECORDS F
>: --- ------------- ----------- -------------- -
>: FPP 23 23 0
 
>: is the result of removing the ||','|| whereas the output required is:
 

>: Affiliate Total Record Add Record Update Record Filler
>: Code, Code, Code, Code,
>: --------- ------------ ---------- ------------- ------
>: FPP, 23, 23, 0
 
>: (I know I forgot to add the split characters in the COLUMN statements)
 

>: Sorry to be pendantic - but it's the format the user area requires &
 insists
>: on and I can find nothing in my notes to cover this exactly!! The
>: only other way I can see of doing it is to do a SELECT then INSERT or
>: UPDATE

 into
>: a new table and run the query again on the new table.
 

>: Regards,
 

>: Neil.
>
>Believe your SQL*Plus column commands are incorrect. For example
>you do not specify a column or alias as a.affiliate_code in your
>query ie try affiliate_code NOT a.affiliate_code instead.
>
>HTH Helen

<unsnip>

Helen,

Sorry - that didn't work either. It gives the column headings the same values as the SELECT statement still. Thanks for trying though!!

Regards,

Neil. Received on Wed Apr 25 2001 - 02:09:55 CDT