saurabh18cs
Honored Contributor III

‎03-30-2026 03:47 AM

Hi  try this  

CREATE OR REPLACE VIEW newview AS
SELECT
  t1.field1,
  structureitem.field2,
  structureitem.field3
FROM table1 AS t1
JOIN table2 AS t2
  ON t1.id = t2.id
JOIN LATERAL TABLE(explode(t1.structure)) AS structureitem
  ON TRUE;