Is the only way to use:
- Code: Select all
$db->query('Select * from....')
$db->query('Select * from....')
select a+.+id, a.description, b+.+name
from table1 a
left exception join table2 b
on a+.+id = b+.+id
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
$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));
Users browsing this forum: No registered users and 4 guests