Dynamic From Clause

[EricBarre]

Hi,

I am trying to dynamically select the db.table used in my query based on the value of a parameter. Something like:
Select *
From
If {?RptPath} = 'GL' Then
gl_table
else
msa_table
end If

Any suggestions on how this would be achievable?

Thanks,
Eric

 

[cjlarue]

you could build the sql statement dynamically and then execute in a stored procedure


Regards
Chuck LaRue
ADRS Computer Services

 

[EricBarre]

I thought about passing the paramters to the SP and execute the appropriate query there, but I would rather not have to if I can. It would be nice to stay within Crystal for such a trivial thing.

Thanks,
Eric