>On 8/14/07, Bill Karwin <[EMAIL PROTECTED]> wrote:
> I think I see where you're going with this. I assume you are currently
> doing this:
>
> $select = $db->select()
> ->from('table1')
> ->join('table2', 'table1.column1 = table2.column1');
>
> And you're prefer to do this:
>
> $select = $db->select()
> ->from('table1')
> ->joinUsing('table2', 'column1');
>
> 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. Let's open a feature request for
> this: http://framework.zend.com/issues/browse/ZF-1845
>
> Also, you might like to use joinNatural(), which would be even more
> concise. It is like USING, but automatically makes an equi-join using
> all columns that have the same name in both tables. Here's how you do
> it in Zend_Db_Select:
>
> $select = $db->select()
> ->from('table1')
> ->joinNatural('table2');
>
Hi Bill,
I might miss the changelog, but I'd like to ask since when is
"joinUsing" implemented?
In ZF 1.0.0, I took a look at Zend/Db/Select.php and I can only find
joinNatural. joinUsing is not there.
Regards,
Mike
