hisystems/DatabaseObjects — Issue #7: Extend table join conditions to include expressions
Author: hisystems
Created: 2012-03-04 06:27:33+00:00
State: open
Labels: High Priority

Currently, table joins only support simple field comparison conditions such as:

```sql
SELECT * FROM Table1 INNER JOIN Table2 ON Table1.KeyField = Table2.KeyField
```

It needs to support more complicated conditions as per the SQLConditions class. For example:

```sql
SELECT * FROM Table1 INNER JOIN Table2 ON Table1.KeyField = Table2.KeyField AND Table1.Name <> ''
```