Data de postagem: May 18, 2010 9:7:51 PM
IQuery.from( -2008889000 /* Títulos */ )
.column("PESSOA.UF")
.execute()
SQL Gerado:
select ENTIDADE2.UF
from TITULO TITULO1
left outer join ENTIDADE ENTIDADE2 on (
TITULO1.PESSOA = ENTIDADE2.CHAVE)
where ((
ENTIDADE2.CLASSE is null or ENTIDADE2.CLASSE in (-2007890000,-2007889000,-2007888900,-2007888000,-2007887900,-2007887800,-2007887000,
-2007886900,-2007886800,-2007886000,-1899999395,-1899998273,-1899997888,-1899933495,
-1898188410,-1898188236,-1897054262,-1897054250,-1897053171,-1897052489,-1897052488,
-1897050888,-1897050838,-1897050521,-1897049480,-1897047849,-1897047848,-1897047846,
-1897037640,-1897037639,-1897037637,-1897037359,-1896048403,-1896048402,-1896047400,
-1895836240,-1894835183,-1894443367,106,107,108,109,110,111,112,114,1923,9865,49345,
49346,49347,49348,51558,51559,170257,173007,173903,176413,178443,182979,185219,187746,
188040,188356,278346,278347,278348,315481,332590,399529,403627,523559,3742881,3742891,
3800974,4141089,4310828,12407575,36230299,39018029,39018048)))
and (
TITULO1.CLASSE in (-2008889000,-2008888890,-2008888790,-1899998525,-1899998524,-1899998370,-1899998369,
-1899998367,-1899933806,51518,51519,35337524,35337539,35337623,35337638))