LEFT JOIN for one to one relation when no data

I have done a one to one relation to show data from foreign key in a list, when there is no data in my detail table records disappear. This is because there is an inner join happening to show detail table and the problem with this is that you cant edit this record anymore.

My suggestion is to use LEFT JOIN Instead of using INNER JOIN for one to one relationships, in order to show just an empty field when there is no detail record.

1 Like