To write a subquery using Zend_Db_Select, you can use the `_

Writing a subquery using zend db?

Question Posted / Aditya Verma

1 Answers
218 Views
I also Faced
E-Mail Answers

Answer Posted / Aditya Verma

To write a subquery using Zend_Db_Select, you can use the `__toString()` method to build your query and nest select statements. Here's an example:

```php
$subQuery = $db->select()->from('table1')
->where('id IN (?)', $ids);
$query = $db->select()
->from('table2')
->join($subQuery, 'table2.id = table1.id');
```

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to call two different views from same action?

302

How you can set module name, controller name, and action name in zend framework?

307

Explain filters in zend framework with examples?

225

How to render zf2 view within json response?

342