Zend_Db_Table and sorting by lookup key

1 message Options
Embed this post
Permalink
Gunter Sammet

Zend_Db_Table and sorting by lookup key

Reply Threaded More More options
Print post
Permalink
Hi all:
Just been wondering if there is a way to sort by lookup key using
Zend_Db_Table. E.g.

My_Customer has a lookup for city id using My_City. Now I want to sort
all customers by city alphabetical (not numeric). Can I do that with
Zend_Db_Table or do I have to construct my own SQL (with joins)?
Thanks,

Gunter