Comunque.

codice:
select (SELECT SUM(entratacamere) + SUM(entrataextra) FROM entrate) as entrate,
(SELECT SUM(importo) AS importo FROM uscite) as USCITE