Zend Framework

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1
• Fix Version/s: 1.5.0
• Component/s: Zend_Db_Select
• Labels:

  None

We can currently do this:

$select = $db->select()
  ->from('table1')
  ->join('table2', 'table1.column1 = table2.column1');

But we'd like to do it more conveniently like this:

$select = $db->select()
  ->from('table1')
  ->joinUsing('table2', 'column1');

So that the resulting SQL statement uses the USING syntax.

The two queries should produce the same result, assuming that your join condition in the first example is an equality between two columns that have the same name in both tables.

Note that USING is followed by a list of columns, comma-separated, inside parentheses.

• Assignee:

  Simon Mundy

  Reporter:

  Bill Karwin

• Created:

  13/Aug/07 7:49 PM

  Updated:

  21/Mar/08 4:25 PM

  Resolved:

  16/Feb/08 7:43 PM