Data de postagem: May 18, 2010 8:54:35 PM
var iQuery = IQuery.from( -2008889000 /* Títulos */ )
iQuery.where({ field: "CHCRIACAO", operator: "=", value: iQuery.column("NUMERO") })
.column("CHAVE")
.toSql()
SQL Gerado:
select TITULO1.CHAVE
from TITULO TITULO1
where (
TITULO1.CHCRIACAO = TITULO1.NUMERO)
and (
TITULO1.CLASSE in (-2008889000,-2008888890,-2008888790,-1899998525,-1899998524,-1899998370,
-1899998369,-1899998367,-1899933806,51518,51519,35337524,35337539,35337623,35337638))