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

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

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