blob: 7b173d8e6a8603bbd52c2e2fea3e91ad4b733678 [file] [log] [blame]
CREATE VIEW vw_neq_jn AS SELECT t1.col_int c1, t2.col_int c2 FROM typeall_l t1, typeall_r t2 WHERE t1.col_int = t2.col_int OR ( t1.col_int IS NULL AND t2.col_int IS NULL );
select count(*) from vw_neq_jn;
drop view vw_neq_jn;