Database View select data from 2 tables

[Piotrekek]

Hello,

I've been struggeling with this issue for a long time and can't find a fix - I need to create a report based on the Problem and Incident tables. All I need to do is create a database view with the records listed from incident and problem - without any left joins, just the records selected from these two tables. Any suggestions? Thanks.

[Ankur Bawiskar · Accepted solution]

Hi,

incident has a field problem_id which stores the problem record; so if you join using these 2 tables using that field then you can see those incidents which has problem associated to it

create database view and use where clause as below

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur