Zend 1 query

$db = Zend_Registry::get('db');
        $sql = "SELECT `origin_order_container`.*, `origin_lcl`.`port_name` AS name
        FROM `origin_order_container`
        Add a comment to this line
        JOIN `origin_lcl` ON `origin_lcl`.`id` = `origin_order_container`.`lcl_id`";
        $stmt = $db->query($sql);
        $result = $stmt->fetchall();