SQL
Q: Find Columns in 5 diff tables using single query -- It help on mapping the columns for data analysis
Solution:
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME IN ('Table1', 'Table2', 'Table3', 'Table4', 'Table5') ORDER BY TABLE_NAME, COLUMN_NAME;
Solution: With CTE can build
WITH alias_name_a ( SELECT * FROM tableA ), alias_name_b ( SELECT * FROM tableB ) SELECT A., B. FROM tableA , TableB