Hi Team, I hope you are doing great. I need few suggestions about below query

Select a.*
>From TableA a,
     TableB b,
     TableC c,
     TableD d
Where a.id = 1234
 and a.id = b.id
 and a.id = c.id
 and c.deptNo = d.deptNo
 and c.name in ('Name1', 'Name2')

tableA and TableD doesn't not have any relation ship.

Can we get count(*) from above query then will check rows doesn't exceed the 
specified limit then will select the fields from TableA

Could you please provide equalant Jooq code for above query?
Iam just trying wil SelectQuery but not able to achieve.  Could you please help 
on this.   Thanks in advance 

-- 
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.

Reply via email to