topic-25872

Board index FiveWin for Harbour/xHarbour tdolphin + INNER JOIN 2 BD

Posts: 43

Joined: Fri Jun 01, 2007 12:41 PM

tdolphin + INNER JOIN 2 BD

Posted: Fri Mar 15, 2013 12:07 AM

eh possivel FAZER um INNER JOIN
ENTRE DOIS BANCOS DIFERENTES USANDO A TDOLPHIN

EXEMPLO BD1 - TABELA1
BD2 - TABELA 2

SELECT T1.produto,T1.descricao,T2.ESTOQLO from dig_gr01.slbdprod as T1 INNER JOIN dig_lj01.slbdploj as t2 on t1.produto = t2.produto

luiz53

Posts: 43

Joined: Fri Jun 01, 2007 12:41 PM

Re: tdolphin + INNER JOIN 2 BD resolvido

Posted: Fri Mar 15, 2013 12:36 AM

oServer:Query("SELECT T1.produto,T1.descricao,T2.ESTOQLO from dig_gr01.slbdprod as T1 INNER JOIN dig_lj01.slbdploj as t2 on t1.produto = t2.produto")

nnicanor

Posts: 302

Joined: Fri Apr 23, 2010 04:30 AM

Re: tdolphin + INNER JOIN 2 BD

Posted: Fri Mar 15, 2013 02:47 AM

Si lo puedes hacer, no hay problema con la cantidad de jions.

Slds

Nicanor Martinez M.
Auditoria y Sistemas Ltda.
MicroExpress Ltda.
FW + FWH + XHARBOUR + HARBOUR + PELLES C + XDEVSTUDIO + XEDIT + BCC + VC_X86 + VCC_X64 + MINGW + R&R Reports + FastReport + Tdolphin + ADO + MYSQL + MARIADB + ORACLE
nnicanor@yahoo.com

FiveTech Support Forums

tdolphin + INNER JOIN 2 BD

Re: tdolphin + INNER JOIN 2 BD resolvido

Re: tdolphin + INNER JOIN 2 BD

Continue the discussion