topic Re: Selecting table Dynamically in Joins in Application Development and Automation Discussions

Selecting table Dynamically in Joins

Former Member — Mon, 13 Oct 2008 09:03:30 GMT

Hi,

i wanna select database table dynamically....im using joins to retrieve the data.

for eg:

select tab1~field1

tab1~field2

tab2~fiield3

innerjoin on

.......................

...................

where .................

...................

Im using use 2 other tables pulling the same data..i wanna select them dynamically.so that i can use only one select statement instead of writing 3 .

plz advise..

thanks

Re: Selecting table Dynamically in Joins

Former Member — Mon, 13 Oct 2008 11:20:58 GMT

Hi,

I tried doing this before a few days. As far as I know, there is no way of using dynamic table names in joins. In normal selects, as you might know, this is possible. But in join it does not allow.

Regards,

Prakash.K

Re: Selecting table Dynamically in Joins

Former Member — Mon, 13 Oct 2008 15:51:53 GMT

Thanks for your reply..

thanks