Need Help Adding New Table into Existing Database View

[Astik Thombare]

Hi Community,

I have a database view that fetches HR cases with SLAs and articles connected to them. I want to add a new table to this view so that it fetches records from both the existing tables and the new table based on specified conditions.

I tried using an `OR` condition to include records from the new table but encountered issues.

Can someone guide me on how to correctly integrate the new table and apply the necessary conditions to include records from all tables?

Thanks in advance!

@-O- 

[Community Alums]

Hi @Astik Thombare ,

What i can make out from your screenshot is, you will need to work on your where clause.

PLease look at this example:

[-O-]

It's hard to give any opinion as long as you don't say what you want to show in that DB view.