10-13-2008 10:03 AM
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
10-13-2008 12:20 PM
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
10-13-2008 12:20 PM
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
10-13-2008 4:51 PM