tdolphin + INNER JOIN 2 BD

tdolphin + INNER JOIN 2 BD

Postby luiz53 » 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


Code: Select all  Expand view  RUN

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

Postby luiz53 » 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")
luiz53
 
Posts: 43
Joined: Fri Jun 01, 2007 12:41 pm

Re: tdolphin + INNER JOIN 2 BD

Postby nnicanor » Fri Mar 15, 2013 2: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
nnicanor
 
Posts: 302
Joined: Fri Apr 23, 2010 4:30 am
Location: Colombia


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 103 guests