Exception Join in Zend\Db 2.8.2 (DB2)

[dan8246]

I can't seem to figure out how to create an exception join using Zend\Db?

Is the only way to use:

Code: Select all

$db->query('Select * from....')

[dan7234]

I cross posted and received an answer on stackoverflow.

Note*: I had to insert '+' throughout this post in order to submit, I'm not allowed to post links and it thinks some of the table qualifiers are links.

https://stackoverflow+.+com/questions/49762937/exception-join-in-zend-db-2-8-2-db2

To recap:

Code: Select all

select a+.+id, a.description, b+.+name
  from table1 a
    left exception join table2 b
      on a+.+id = b+.+id


I equivalent to:

Code: Select all

select a+.+id, a.description, b+.+name
  from table1 a
    left outer join table2 b
      on a+.+id = b+.+id
  where b+.+id is null

So something like this would work:

Code: Select all

$select = new Select();
$select->columns(array('id', 'description'));
$select->from(array('a' => 'table1'));
$select->join(
    array('b' => 'table2'),
    'b+.+id = a+.+id',
    array('name'),
    $select::OUTER
);
$select->where(array('b+.+id' => null));