thekid/rfc — Issue #198: RFC 0198: Joins with criteria
Author: thekid
Created: 2011-10-09 15:44:58+00:00
State: open

Scope of Change
====

Rationale
====

Functionality
====

SQL:

```
select
e.event_id as id,
e.title,
e.description,
l.name as location
from
event e,
location l
where l.location_id = e.location_id
and e.bz_id= 20000

```

```php
on(Event::getPeer())
->join(Location::getPeer(), 'location_id')
->add('bz_id', 20000, EQUAL)
;
?>
```

Security considerations
====

Speed impact
====

Dependencies
====

Related documents
====

Comments
====