That will work.
Here's a real-life example I just changed using your question:
select
ii.partno,sum(ii.inv_qty),extractweekday(ih.inv_date),ih.inv_date,ih.acno
"account number"
from invhead ih
join invitems ii
on ii.inv_nmbr=ih.inv_nmbr
group by ii.partno,ih.inv_date,ih.inv_date,ih.acno
select
ii.partno,sum(ii.inv_qty),extractweekday(ih.inv_date),ih.inv_date,ih.acno as
"account number"
from invhead ih
join invitems ii
on ii.inv_nmbr=ih.inv_nmbr
group by ii.partno,ih.inv_date,ih.inv_date,ih.acno
Note that you do not require the "AS" although it may help with readability.
Alan J Davies
Aldis
On 19/04/2013 16:14, ramona.grissom wrote:
> How can we accomplish this in Firebird?
>
> In MSSQL for example you can SELECT column AS [column name]. The "column
> name" can contain spaces and be named a reserved word because it's
> escaped with the square brackets.
>
> But not sure about
>
> SELECT CustomerName AS "Customer Name"
> FROM Customers
>
> Thank you in advance for your help.
>
>
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
