framework/resources/Functional/joins/inner/2way_on_2_cols.sql

select
        count(*)
from
        j1 INNER JOIN j4 ON
        (
         j1.c_date = j4.c_date
 	and j1.c_time = j4.c_time

        )
where
        j1.c_date IN (select c_date from j2)
	--and exists (select c_time from j3 )
	and cast(j1.c_integer as bigint) <> j4.c_bigint
;