come ha detto claksu, la CROSS JOIN dovrebbe fare per te

select * from
(select item1 from TABELLA) t1
CROSS JOIN
(select item2 from TABELLA) t2
CROSS JOIN
(select item3 from TABELLA) t3