Add ON clause to the left join of drupal views query
Drupal views provide an interactive UI to present almost any data from the database to the user. To add any left join to the query generated by our view, we normally add relationships to the view table. This page illustrates how to Add ON clause to the left join of drupal views query.