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