i am writing a function to return a table in the select query i am using a join and for some columns i want to give alias name but alias name given within" " is not accepting pls give me some suggestions as soon as possible

select a.answer as "choice",a.answerno as "choiceno",q.questionid,q.answer as "answerno",
q.solution,s.question from answer a , question q, qpselection s where (q.questionid=a.questionid )
and (s.questionid =a.questionid ) and s.qpid =$1

this is the query i tryed to run within the function

sql union query

database management systems

dbms comparison

sql server 2008 download

dbms basics

sql basics

sql server versions

dbms questions

database schema examples

sql online training

sql cast function

free database software

learn sql online

sql update join

sql server 2008 r2

movie database software

online database management

sql server versions

database designers

dbms history