Zend_Db_Select help with join

Question

i'm using the following code and get the following error

$select = $model->select();
$select->from(array('stocktakejob'), 
            array("ProductID" => "stocktakejob.ProductID",
                    "TotalCount" => "SUM(stocktakejob.NewCount)"
              )
       )->join(array('products'),
               'products.ProductID = stocktakejob.ProductID', 
               array("ProductCode" => "products.ProductCode")
       )->where("stocktakejob.StockTakeID = ".$stocktake->getStockTakeID())
       ->group('stocktakejob.ProductID');

error: Exception

Select query cannot join with another table

Is there something i'm missing ? anyhelp would be appreciated.

Marcin · Accepted Answer · 2011-05-03 00:12:56Z

3

I think that you should set integrity check to false when making join statements:

$select->setIntegrityCheck(false);

answered May 3, 2011 at 0:12

Marcin

241k16 gold badges315 silver badges368 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

roguecoder Over a year ago

that was the answer thanks a million. cant believe i was missing that.

Collectives™ on Stack Overflow

Zend_Db_Select help with join

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related