Never mind, it just works :-) I should have tried it before I posted this.
Thanks for an awesome API. On Wednesday, January 9, 2013 10:11:54 AM UTC-6, John Childress wrote: > > Can I query across schemas with jOOQ? I know how to do it in sql, so I > thought/figured it would work in jOOQ. I'm just having trouble figuring it > out. > > I've included a sample of what I'm trying to achieve: > > *select * > * sfd.* * > *from * > * myschema.sample_prices sfd,* > * otherschmea.price_nodes pn* > *where * > * pn.node_id = sfd.node_id and* > * pn.state = 'TX' and* > * sfd.price_date = (select max(price_date) from myschema.sample_prices > sfd, otherschmea.price_nodes pn where pn.node_id = sfd.node_id and > pn.state = 'TX')* > > thanks, > > John >
