Zend Db Table Double JOIN

[debbieroyal]

\[code\]1. plan_payment_type: id plan_id2. plan id payment_period\[/code\]It is Foreign key between \[code\]plan_payment_type.plan_id\[/code\] and \[code\]plan.id\[/code\]. In my code I know a $plan_payment_type_id.My task is to select \[code\]payment_period\[/code\].Steps:

• Select \[code\]plan_id\[/code\] from \[code\]plan_payment_type\[/code\]
• Select \[code\]payment_period from\[/code\] \[code\]plan\[/code\] with selected \[code\]plan_id\[/code\]

How can I do it with one query in Zend Framework?Thank you very much.