Zend_Db_Table 子查询

2021-12-29 00:00:00 subquery php zend-framework 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"));

相关文章