Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
joins
/
nulleqjoin
/
join_on_nulls.q
blob: febf8e5d1a5afc1e7945de2f0ad8878085bc3ec7 [
file
] [
log
] [
blame
]
select
l
.
col2
,
r
.
col1
from
lallnulls l
,
rallnulls r
where
l
.
col1
=
r
.
col2 OR
(
l
.
col1 IS NULL AND r
.
col2 IS NULL
);