# Table Gateways select query

**URL:** <https://discourse.laminas.dev/t/table-gateways-select-query/221>\
**Category:** Components & MVC\
**Tags:** zend-mvc\
**Created:** [July 23, 2017, 7:49pm UTC](https://discourse.laminas.dev/t/table-gateways-select-query/221 "2017-07-23T19:49:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![karango](https://avatars.discourse-cdn.com/v4/letter/k/f04885/32.png) [@karango](https://discourse.laminas.dev/u/karango)\
**Post date:** [July 23, 2017, 7:49pm UTC](https://discourse.laminas.dev/t/table-gateways-select-query/221/1 "2017-07-23T19:49:55Z")

</div>

hi,  
I need your help,i’d like to know how to create a select query using from clause, where condition and order by in zend framework?  
for example if i want to translate this sql query “select cmd\_id,cmd,article,date\_cmd,qte from commands join line\_commands using(cmd\_id) where qte\>5 order by date\_cmd”; how can i do? i’m using zend framework 3, postgresql .  
help me please!

---

<div class="post-metadata">

**Author:** ![ocramius](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/ocramius/32/23_2.png) [@ocramius](https://discourse.laminas.dev/u/ocramius)\
**Post date:** [July 24, 2017, 5:38am UTC](https://discourse.laminas.dev/t/table-gateways-select-query/221/2 "2017-07-24T05:38:38Z")

</div>

Please refer to the documentation. For example, see  
[https://zendframework.github.io/zend-db/table-gateway/](https://zendframework.github.io/zend-db/table-gateway/)

Marco Pivetta

[http://twitter.com/Ocramius](http://twitter.com/Ocramius)

[http://ocramius.github.com/](http://ocramius.github.com/)