0

I Want to write this normal mysql query to zendquery

SELECT *,(select GROUP_CONCAT(keyword_name,',') 
   from keyword k inner join keyword_product_mapping m 
       where k.keyword_id=m.keyword_id and m.product_id=p.product_id) 
           FROM product p
Improve this question
4
  • Did you make any attempts to solve it that you could share? Commented Nov 4, 2014 at 6:01
  • Exactly i dont know how to write sub query in zend. The normal query is a working one. Commented Nov 4, 2014 at 6:04
  • First write the subquery in Zend, then write the main query (without specifying the subquery) in Zend. Post that here and we'll be able to help you with patching them together ;-). Commented Nov 4, 2014 at 9:22
  • Maybe it will help you stackoverflow.com/questions/4922246/… Commented Nov 4, 2014 at 12:22
Related questions
0
Zend Framework normal query to Zend_Db_Table
1
zend framework query
20
RAW SQL Query with Zend Framework
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.