blob: b28b22fc76b13bdf81e37e310924fbfd362c6c42 [file] [log] [blame]
with a as ( select * from `test.json` ) select * from a, `test.json` b where a.CUSTOMERID = b.customerid;