blob: 1030d7d0f83f4ea6a97a65bcc45256066193ffb6 [file] [log] [blame]
select
count(*)
from
j1 INNER JOIN j4 ON
(
j1.c_date = j4.c_date
and j1.c_time = j4.c_time
and j1.c_timestamp = j4.c_timestamp
and j1.c_boolean = j4.c_boolean
and j1.c_varchar = j4.c_varchar
and j1.c_float = j4.c_float
)
where
j1.c_date IN (select c_date from j2)
--and exists (select c_float from j3 )
and cast(j1.c_integer as bigint) <> j4.c_bigint
;