I hit post before I was finished. Apologies all. The query I was writing was something along the lines of:
SELECT a.x, b.y FROM table_a a, table_b b WHERE (SELECT MAX(b.y) WHERE b.x = a.x); Some advice on how to go about doing something like this with Sequel, or a link to appropriate docs would be appreciated. Cheers, Brenton On Tuesday, 6 August 2013 11:06:38 UTC+10, Brenton Annan wrote: > > Hi, > > I'm using sequel in some rake tasks to sync Oracle and MSSQL dbs with > MySQL. I like it so far, however I can't seem to find relevant > documentation for doing the following: > > SELECT * FROM table_a a WHERE (SELECT MAX(b.column) WHERE b.c > -- 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/groups/opt_out.
