Select All columns from multiple tables
How to select all columns from multiple tables in the BI Data model.
select a.*, b.* from table1 a,table2 b
I cannot execute above sql statement when both the tables having duplicate columns (eg. creation_date,created_by). In this case, I need to mention all columns in the SELECT statement which is a time consuming process by eliminating duplicate columns. Is there any way to select all columns even though there are duplicate columns?