Re: join tables with substitution where values exist, else use existing values

[David Koski]

My approach was going to be to use a query source identification string or integer as part of the query. Or use an "if/else" statement:

IF <destination_is_here>
<use_mymethod>
ELSE
<get_method_from_table>
FI

That would eliminate the requirement to have a table or view for each query source. The the only issue left is to get the substitutions working conditionally.

Another approach would be to generate tables for each query source with scripts each time there was a modification in the main table.

Regards,
David Koski
[e-mail]