PHP Solutions

(Join 2 or more tables)
$select = $RelatedTable->select(true)->setIntegrityCheck(false);

(Union tables)
$adapter = $dbTable->getAdapter();

$sqlsvn=’sql goes here’

$dbRow = $adapter->fetchAll($sqlsvn, Zend_Db::FETCH_ASSOC);