Sorry, but there are something that I can do in this case? *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> Mob +55 (18) 99764-2733 <callto:+5518997642733> Ph +55 (11) 3522-8009 http://about.me/dannyeuu
Av. Nova Independência, 956, São Paulo, SP Bairro Brooklin Paulista CEP 04570-001 https://www.bankfacil.com.br On Thu, Sep 3, 2015 at 4:12 PM, Daniel Lopes <[email protected]> wrote: > Hi, > > There are somthing that I can do this? > > SELECT > tb.id, > (SELECT tb3.field FROM database.table2 tb2 JOIN database.table3 tb3 ON ( > tb3.id = tb2.table3_id) ORDER BY tb3.date DESC LIMIT 1) AS tb3_field > FROM database.table1 tb1 > > > Best, > > *Daniel Lopes, B.Eng* > Data Scientist - BankFacil > CREA/SP 5069410560 > <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> > Mob +55 (18) 99764-2733 <callto:+5518997642733> > Ph +55 (11) 3522-8009 > http://about.me/dannyeuu > > Av. Nova Independência, 956, São Paulo, SP > Bairro Brooklin Paulista > CEP 04570-001 > https://www.bankfacil.com.br > >
