Rename columns within a query?
is there way can rename column within coldfusion query? i've attached example.
i've joined table same table here , have named them , b. want able rename columns in b that, when display output, not have same names in a. (eg. b_pkgname , b_pkgrev).
i've joined table same table here , have named them , b. want able rename columns in b that, when display output, not have same names in a. (eg. b_pkgname , b_pkgrev).
brandi l wrote:
> there way can rename column within coldfusion query?
yup , in other technology making use of sql supports
alias 'as' statement.
i.e.
select
a.site,
a.pkgname,
a.pkgrev,
b.pkgname b_pkgname,
b.pkgrev b_bkgrev
...
i hear things ben forta's "teach sql in 10 minutes"
as many sql references , tutorials available on internets.
> there way can rename column within coldfusion query?
yup , in other technology making use of sql supports
alias 'as' statement.
i.e.
select
a.site,
a.pkgname,
a.pkgrev,
b.pkgname b_pkgname,
b.pkgrev b_bkgrev
...
i hear things ben forta's "teach sql in 10 minutes"
as many sql references , tutorials available on internets.
More discussions in Database Access
adobe
Comments
Post a Comment