I am building a views plugin and I need it to do this:
LEFT JOIN my_table mt ON (mt.nid = node.nid AND mt.value = 'some argument');
I have found documentation for creating a views plugin, but all of the documentation that I have found doesn't say anything about creating view joins like this.
Is it possible? If so, how do I go about doing something like this?