First table's where clause ignored in database view with left join

Defining a 'where' clause on the first View Tables (sorting with order) doesn't work when one of the View Tables has 'Left join' set to true.

All

Database view behavior is intentional, as View Table defines 'join'. No issue with 'where' clause for inner join ('left join'=false); recorded in PRB1348874.

Add a View Table to enable the where clause for the first table. See screenshot below (View Tables).