Join clm_m2m_contract_asset and alm_hardware tables

[GisleH]

Hi.

Im trying to create a report that shows asset with and without a contract.

Report need to show asset and contract information (also asset that does not have a contract) 

is there anyway to join clm_m2m_contract_asset and alm_hardware tables ? 

[GisleH]

Hi, this gives same error.

[GisleH]

Hi.

i get the same issue with this.
any suggestions ?

[Bhavya11]

hi @GisleH 

could you please share your database view screenshot

like if you try as mentioned by @Runjay Patel  it wont throw any error

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Thanks,

BK

[GisleH]

The database view is just showing the records using an inner join, but we want all the records from left table and all the records from the right table.