**Edited to reflect earlier omission:**
I want to define a relationship of 0 to 1 rows where there will never be more than 1 child row:

```
...
@JoinColumn(name="INVENTORY_ID", referencedColumnName="INVENTORY_ID")
@OneToOne
private QOH qoh;
...

```

So my problem is I have tried every way to use @OneToOne without @JoinColumn and with it and no matter what I do the SQL generated by Hibernate when selecting a subset of fields causes an inner join meaning that the Item records that have no QOH record are not returned:

```
...
SELECT i.inventoryId,i.name,i.qoh.quantity FROM Item i;
...

```

If I had full control over the database I'd enforce the creation of a QOH record anytime an Item is created but I don't control the database nor the access to it. Can Hibernate do this for a child entity?:

```
...
SELECT ... FROM Item i LEFT OUTER JOIN QOH q ON q.INVENTORY_ID = i.INVENTORY_ID
...

```

instead of:

```
...
SELECT ... FROM Item i, QOH q WHERE q.INVENTORY_ID = i.INVENTORY_ID
...

```