You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Select All columns from multiple tables

in Reporting and Analytics for ERP 1 comment

Hi All,

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!