Hi

I am making a session query where i join 3 classes like so:

var aliasUser = new AqlAliasTestUser();

var aliasOrder = new AqlAliasTestOrder();

var aliasOrderItem = new AqlAliasTestOrderItem();

var join = new AqlAliasRelCustomerOrders(aliasUser, aliasOrder);

var join2 = new AqlAliasRelOrderItems(join, aliasOrderItem, aliasOrder);

now when i query i only get results where i have hits in all 3 tables, however I don't always have orderitems, but I would like to search for them, giving a searchword, if they are present.

Can I do a left join in any way to achieve this?

regards

Christoffer