FieldBox

When you want to get a row list of data from multiple tables

In Daobab you don't need to use @JoinColumn at all.
And surelly you don't need to hardcode any painful relations into entity.
Just anytime you need, point what related columns Daobab schould retrieve.

SQL: select pizza.name,pizzaprice.price from pizza Pizza pizza, PizzaPrice pizzaprice,PizzaSize pizzasize
	where pizzasize.name="big
		and pizzasize.pizzasize_id=pizzaprice.pizzasize_id 
		and pizzaprice.pizza_id=pizza.pizza_id"; 
FieldBox row=Select.fieldBox(daoPizza.colName(),daoPizzaPrice.colPrice())
	.where(Where.AND()
		.and(daoPizzaSize.relPizzaSize(),bigSize)
		.and(daoPizzaPrice.relPizza(),daoPizza.relPizza())
		.and(daoPizzaPrice.relPizzaSize(),daoPizzaSize.relPizzaSize())
	).result();

Next, having FieldBox, you need to get List and unbox data.

To do this just check out the FieldBox tab

or consume it:

Select.fieldBox(daoPizza.colName(),daoPizzaPrice.colPrice())
	.where(Where.AND()
		.and(daoPizzaSize.relPizzaSize(),bigSize)
		.and(daoPizzaPrice.relPizza(),daoPizza.relPizza())
		.and(daoPizzaPrice.relPizzaSize(),daoPizzaSize.relPizzaSize())
	).consumeResult(DoSomething::withFieldBoxNamePrice);