<legend id='8IMpj'><style id='8IMpj'><dir id='8IMpj'><q id='8IMpj'></q></dir></style></legend>

    <i id='8IMpj'><tr id='8IMpj'><dt id='8IMpj'><q id='8IMpj'><span id='8IMpj'><b id='8IMpj'><form id='8IMpj'><ins id='8IMpj'></ins><ul id='8IMpj'></ul><sub id='8IMpj'></sub></form><legend id='8IMpj'></legend><bdo id='8IMpj'><pre id='8IMpj'><center id='8IMpj'></center></pre></bdo></b><th id='8IMpj'></th></span></q></dt></tr></i><div id='8IMpj'><tfoot id='8IMpj'></tfoot><dl id='8IMpj'><fieldset id='8IMpj'></fieldset></dl></div>

    <small id='8IMpj'></small><noframes id='8IMpj'>

  1. <tfoot id='8IMpj'></tfoot>
        <bdo id='8IMpj'></bdo><ul id='8IMpj'></ul>
    1. Zend_Db_Table 子查询

      时间:2023-05-31
      <i id='6gLCk'><tr id='6gLCk'><dt id='6gLCk'><q id='6gLCk'><span id='6gLCk'><b id='6gLCk'><form id='6gLCk'><ins id='6gLCk'></ins><ul id='6gLCk'></ul><sub id='6gLCk'></sub></form><legend id='6gLCk'></legend><bdo id='6gLCk'><pre id='6gLCk'><center id='6gLCk'></center></pre></bdo></b><th id='6gLCk'></th></span></q></dt></tr></i><div id='6gLCk'><tfoot id='6gLCk'></tfoot><dl id='6gLCk'><fieldset id='6gLCk'></fieldset></dl></div>
    2. <legend id='6gLCk'><style id='6gLCk'><dir id='6gLCk'><q id='6gLCk'></q></dir></style></legend>

      <tfoot id='6gLCk'></tfoot>

          <bdo id='6gLCk'></bdo><ul id='6gLCk'></ul>
            <tbody id='6gLCk'></tbody>

              1. <small id='6gLCk'></small><noframes id='6gLCk'>

                本文介绍了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 子查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                上一篇:pcntl_fork 和 MySQL 连接消失了 下一篇:Zend_Controller_Router_Exception:“xyz";未指定

                相关文章

              2. <i id='JHPWu'><tr id='JHPWu'><dt id='JHPWu'><q id='JHPWu'><span id='JHPWu'><b id='JHPWu'><form id='JHPWu'><ins id='JHPWu'></ins><ul id='JHPWu'></ul><sub id='JHPWu'></sub></form><legend id='JHPWu'></legend><bdo id='JHPWu'><pre id='JHPWu'><center id='JHPWu'></center></pre></bdo></b><th id='JHPWu'></th></span></q></dt></tr></i><div id='JHPWu'><tfoot id='JHPWu'></tfoot><dl id='JHPWu'><fieldset id='JHPWu'></fieldset></dl></div>
                  <bdo id='JHPWu'></bdo><ul id='JHPWu'></ul>
                <tfoot id='JHPWu'></tfoot>

                    <legend id='JHPWu'><style id='JHPWu'><dir id='JHPWu'><q id='JHPWu'></q></dir></style></legend>

                  1. <small id='JHPWu'></small><noframes id='JHPWu'>