drop table if exists aaa;
drop table if exists bbb;

create temp table aaa(id int, count int);
create temp table bbb(id int, count int);

insert into aaa values (1, 2);
insert into bbb values (1, 2);

select * from aaa a
	left join bbb b on a.id = b.id
where a.count > b.count;

select * from aaa a
	left join bbb b on a.id = b.id
where nvl(a.count,0) > nvl(b.count,0);

Database selected.

Table dropped.
Table dropped.

Temporary table created.
Temporary table created.

1 row(s) inserted.
1 row(s) inserted.

         id       count          id       count 

No rows found.


         id       count          id       count 

          1           2                        

1 row(s) retrieved.