Re: [SQL] How to cal function in one another

2006-08-02 Thread Aaron Bono
On 8/2/06, Penchalaiah P. <[EMAIL PROTECTED]> wrote:   hai, In mainfun,the query returns more than two rows,if execute query outside. I have to remove limit keyword in mainfun defination...even it returns 1st row values only..But i need the multful rows? so how can i do that...p

[SQL] How to cal function in one another

2006-08-02 Thread Penchalaiah P.
  hai, In mainfun,the query returns more than two rows,if execute query outside. I have to remove limit keyword in mainfun defination...even it returns 1st row values only..But i need the multful rows? so how can i do that...please help me...   select subfun1(22);    subfun1 ---