本文介绍了Zend_Db_Table 子查询的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
我有一些 SQL 想与 ZendFW 一起使用，但我无法让它工作，这让我发疯.我通过这个查询得到了正确的结果:
I have a some SQL that I want to use with ZendFW, but I can't get it working and it's driving me crazy. I get the correct result with this query:
SELECT DISTINCT e.festival_id FROM entries AS e, mail_log as m
WHERE e.status = 1
AND e.festival_id
NOT IN (SELECT m.entry_id FROM entries AS e, mail_log as m WHERE m.entry_id = e.festival_id)
帮助将不胜感激.干杯:)
Help would be appreciated. Cheers :)
推荐答案
Goran 的答案是最好的答案.但是如果你想要一个 zend_db_table 样式的查询，这将是一个替代:
Goran's answer is the best answer. But if you want a zend_db_table style query, this would be an alternative:
$sql = $table->select()
->setIntegrityCheck(false)
->from('entries', new Zend_Db_Expr('DISTINCT festival'))
->where('status = ?', 1)
->where('festival_id NOT IN (?)',new Zend_Db_Expr("SELECT m.entry_id FROM entries AS e, mail_log as m WHERE m.entry_id = e.festival_id"));
这篇关于Zend_Db_Table 子查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！