I have two database instance, how use

I have two databases, example database 1 and database 2, how to change the results of the “select * from”, from a filter, where the user would choose the database.

there is a way to use a “use db” with “db” being the return of the variable, or any other way hahah

welcome

best approach would be to create a view for both tables in either one of the databases

1 Like