I need help in creating a database view between two custom tables where I am not able to find common field them but there are 2 fields which are showing same result. Name of the field is Application Name and Asset name.

[User496826]

I need help in creating a database view between two custom tables where I am not able to find common field them  but there are 2 fields which are showing same result. Name of the field is Application Name and Asset name.

[Mark Manders]

In what way are they showing the same result? Are they referencing the same table? In that case that's your common field. If not, you can't create a db_view, because you need to have an overlap between the tables. 

Maybe add a 3rd that has a reference to both of the tables?

[User496826]

They are showing same result in respect of application name and asset name. In one table Field - Application Name is showing same result as on another table - Asset name .There is no table which is common between these two tables.

[Mohith Devatte]

hello ruchi ,

you can create a data base view and create two view tables 

1) Custom table 1 with order 100 and no where clause and prefix as cus1

2)Custom table2 with order as 200 and  prefix as cus2 where clause would be cus2_applicationfieldname= cus1_assetfieldname

try this 

if it works please mark my answer correct 

[User496826]

I tried but it is not showing any record