|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
![]() |
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 |
||||
Powered by
DBNest.com (Nest of DB Professionals)
