>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.

Field2 fields possibly have NULL value.