Hi everybody,

If I have SQL like

select table1.* from table1 inner join table2 on table1.field1=table2.field1 and table1.field2=table2.field2

and tables have empty field2, these records are not included into final result.

How can I include them into result?

Thanks a lot in advance.