Hi Lukas,
I want to add couple of nested select statements to my SelectQuery<Record>.
- Sample JOOQ query,
SelectQuery<Record> selectQ = dsl.selectQuery();
selectQ.addSelect(a.id,a.name,*<????>*,a.date);
selectQ.addFrom(a);
selectQ.addConditions(a.id.equal(aId).and(a.date.equal(new
java.sql.Timestamp(aDte.getTime()))));
return selectQ.fetch()
- Actual Requirement in plain SQL,
Select a.id, a.name, *(select val from myProcedure(a.value))*, a.Date from
a Where (a.id=aId) and (a.date=aDte)
Could you please shed me some light on this?
Thanks,
Buddhika E.
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
