Error: Select query cannot join with another table

I was joining two tables in Zend framework. I come across following error:

Error:  Select query cannot join with another table

The code that I was using is as below:

$calc = $this->select()
  ->from(array('c'=>'sed_cal'),array('c.id','c.name'))
  ->join(array('ctr'=>'sed_calc_to_road'),'c.id = ctr.calc_id')
  ->where('ctr.road_id',$id)
  ->order(array('c.id ASC'));

After searching the web, I found that I need to use the setIntegrityCheck function with false value. Hence, the code goes as this:

$calc = $this->select()
  ->setIntegrityCheck(false)
  ->from(array('c'=>'sed_cal'),array('c.id','c.name'))
  ->join(array('ctr'=>'sed_calc_to_road'),'c.id = ctr.calc_id')
  ->where('ctr.road_id',$id)
  ->order(array('c.id ASC'));

See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide

List of my works:

Technical Support:

If you still face the technical problem, please get support of our highly skilled technical team: garazlab.com.


Wordpress Plugins:

1. Real-Time Health Data from Every Where:WP plugin to display real-time health data & increase sale by promoting user specific products according to health information: garazlab.com.
2. Woocommerce Stock Notification Builder:Sends desktop, mobile & email notifications with full customization.Build your own product notification system with it: garazlab.com.

Opencart Extensions:

1. Product Based Quantity Wise Shipping: Find it here.
2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

1. OpenCart 1.4 Template Design Cookbook.
2. Joomla Mobile Development Beginners Guide