I've got a database with about 100 tables and I need to build a join query to get specific data from two of them. I know one but not the other. Basically I need something like:
select <tables> from <database> where exists table.column name;
How can I do this?
Best Answer
Using
information_schema
This is the standards-compliant cross-RDBMS way to do it.
You can see this documented