Is it what you mean:
Let us suppose that user selected "apr03" from the user dialog and the value is stored in the variable lcMonth.
sele * from ("pay"+lcMonth)...
>Hello
>
>In a client-server environment , how can retrieve data from tables by SQL
>
>eg i have payfiles like PayJan03,payFeb03,PayMar03 and if the user select Jan 03 .. Apr03 how can select the data by SQL into a temp table ?
>
>TIA
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only