Where clause on the first table is ignored on database view when left join is set to trueIssue <!-- div.margin { padding: 10px 40px 40px 30px; } table.tocTable { border: 1px solid; border-color: #e0e0e0; background-color: #fff; } .title { color: #d1232b; font-weight: normal; font-size: 28px; } h1 { color: #d1232b; font-weight: normal; font-size: 21px; margin-bottom: 5px; border-bottom-width: 2px; border-bottom-style: solid; border-bottom-color: #cccccc; } h2 { color: #646464; font-weight: bold; font-size: 18px; } h3 { color: #000000; font-weight: bold; font-size: 16px; } h4 { color: #666666; font-weight: bold; font-size: 15px; } h5 { color: #000000; font-weight: bold; font-size: 13px; } h6 { color: #000000; font-weight: bold; font-size:14px; } ul, ol { margin-left: 0; list-style-position: outside; } --> Symptoms Defining a where clause on the first View Table (sorting with order) doesn't work when one of the View Tables has left join set to true. Release All Versions Cause This behavior of database view is intentional since View Table defines how the two tables are joined. There is no issue with where clause while using inner join (left join = false). This has been recorded in PRB1348874 Resolution The workaround for this issue is to create an additional View Table to add the where clause for the first table. See the attached screenshot with an example database view (View Tables) to make the where clause work on the first View Table.