• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
join beteween two tables in diferent db

#1
[eluser]mmiranda[/eluser]
Hi, i have an voip appliance with mssql server with two databases, agent and billing, for some reason in the billing db there is not the telephone number in any table, it is in the agent db, so i have to join two tables within diferent db's, ie:

select a.timeOfBilling, a.credit, a.charge, b.cli

from BILLING.dbo.billing_200712 a, AGENT.dbo.multi_cli b

where a.productName=b.productName

and a.batchNumber=b.batchNumber

and a.serialNumber=b.serialNumber

How (if posible) can i code that query in codeignitor's active record library?


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.