MySQL Join a Table if Exists Question
- by swhitlow
I have a DB which has a table called "config". This table could possibly have a "config_cstm" table that is related by the id to the config table.
I was wondering - is there a way to dynamically check for the existence of this table in one simple select statement?
In other words, something like:
"select * from config (IF EXISTS config_cstm THEN…