Hi, I've tried to read the docs but haven't been able to figure out how to get the two following where clauses ORed together
.where(:OACUOR => request[:customersOrderNumber]) .where(db[:OOLINE].where( :OBCONO => request[:company], :OBORNO => :OAORNO, :OBCUOR => request[:customersOrderNumber]).exists)) i.e. the resulting SQL should be select * from foo WHERE (:OACUOR='foo') OR (EXISTS(SELECT * FROM OOLINE WHERE OBCONO=100 AND OBORNO=OAORNO AND OBCUOR='foo')) How to achieve that? (I'm using the jdbc/as400 adapter if that matters) And thanks for sequel btw! regards, Simon -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
