Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
joins
/
inner
/
2way_on_c_date.sql
blob: 7a48a4367e51d3d3217405c8ffcb8e0c3ca0fcad [
file
] [
log
] [
blame
]
select
count
(*)
from
j1
INNER
JOIN
j2
ON
(
j1
.
c_date
=
j2
.
c_date
)
where
j1
.
c_bigint
IS
NOT
DISTINCT
FROM
j2
.
c_bigint
and
j1
.
c_date
IS
NOT
NULL
;