Hello @Shabbir1
You can learn the same via out-of-the-box Database View "incident_sla" which is quite useful for many:
Yes, you are right - When there is atleast one common field among tables (two tables in your scenario) then you can use that field in where clause as shown below:
Under the view tables, where both of these tables are listed you can open them both and under View Fields Click New:
This will help you to bring all those fields/columns from both the tables which you really need:
In your Database view form, Under Related Links click Try it:
Click Personalized List gear icon:
and bring all the fields from right to left by ensuring which one to display where:
You will notice that both the tables have Created however their backend names in paranthesis describes from which table (table prefix you added) they are from:
NOTE: You can also right click on any column name and click Configure List Layout to Save this as Default view.
Challenge here is that the column names cannot be re-labeled as per our need until you are allowed to actually update the column label in the dictionary of these two tables.
