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
