Oracle View Sample

CREATE OR REPLACE VIEW dd
(d1, d2)
AS
SELECT t1.d1, t2.d2 from aaa t1, bbb t2 where t1.z = t2.z