SELECT A.pippo as pippoA, B.pippo as pippoB FROM tabella1 A, tabella2 B