Bill Karwin 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
Something like that yes. I generally have the join columns the same
name, and then set foreign keys to them aswell. It would be nice if they
were picked up automatically.
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');
Both USING and NATURAL JOIN syntax forms are ANSI SQL standard, but do
all our supported database brands support these forms?
Interesting. Yes I was also looking at this. Ive never used this keyword
at all. usually INNER so it collects the least ammount of rows. Is it
the same pretty much, but just automatically detects the join columns ?
Im assuming like foreign keys the join columns need to be the same type.
