Selecting table Dynamically in Joins

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks for your reply..

thanks