How can I create a DAL Select statement from a SQL exists clause?

[George D Elig]

I have the following SQL statement that I'm having difficulty converting to a db()Select statement. I could use a left join but I can only return one row, which is being addressed with 'limit 1'

select sites.domain_name, batch.batch_name from sites, batch

where exists (select batch.id from batch

              where sites.batchid = batch.id) limit 1

Thanks in advance for any assistance.

D.

[Massimo Di Pierro]

Unfortunately you will have to use db.executesql for this.