Join in controller method

declare variable first

protected $db;

then in controller __construct()

$this->db = db_connect();

now your are ready to use.

$this->db->select('tratte_acquistate.*');