"SELECT *, geral_cnpj as cnpj, geral_mesref as mesref, (SELECT CEILING(( (SELECT `geral_valor_total` as valormes from tbl_geral where `geral_cnpj`=cnpj and `geral_mesref`=mesref) - (SELECT `geral_valor_total`from tbl_geral as valormesanterior where `geral_cnpj`=cnpj and `geral_mesref`=mesref-1) ) / (SELECT `geral_valor_total`as valormes from tbl_geral where `geral_cnpj`=cnpj and `geral_mesref`=mesref)*100 ) ) as valor_percentual FROM tbl_geral";

Error Number: HY000/1096
No tables used
SELECT *

public function listar_gerais_percentual(){

   $q="SELECT *, geral_cnpj as cnpj, geral_mesref as mesref, (SELECT CEILING(( (SELECT `geral_valor_total` as valormes from tbl_geral where `geral_cnpj`=cnpj and `geral_mesref`=mesref) - (SELECT `geral_valor_total`from tbl_geral as valormesanterior where `geral_cnpj`=cnpj and `geral_mesref`=mesref-1) ) / (SELECT `geral_valor_total`as valormes from tbl_geral where `geral_cnpj`=cnpj and `geral_mesref`=mesref)*100 ) ) as valor_percentual FROM tbl_geral";



  $result = $this->db->query($q);

  return $result;

}