Home » SQL & PL/SQL » SQL & PL/SQL » join two tables with ip (mysql)
join two tables with ip [message #353204] Sun, 12 October 2008 15:39 Go to next message
roman.rule
Messages: 1
Registered: October 2008
Junior Member
hello i want to join two tables using ip address through sql
can any one help
select * from db1.table1 union select * from db2.table2;
this is used for join two tables from the same pc
what command is used for joining the tables if they are not in same pc ?
thanks help will be appreciated
Re: join two tables with ip [message #353205 is a reply to message #353204] Sun, 12 October 2008 16:30 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
If you mean from two servers/databases try to look on database link.

*I just noticed your db version. Just a note, this is an Oracle Forum.

[Updated on: Sun, 12 October 2008 16:31]

Report message to a moderator

Re: join two tables with ip [message #353214 is a reply to message #353204] Sun, 12 October 2008 23:06 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
If you wanna see examples ... search google or
http://sadatdba.blogspot.com/2008/10/database-link-in-oracle.html
Re: join two tables with ip [message #353216 is a reply to message #353204] Sun, 12 October 2008 23:10 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
I am extremely sorry for the previous post. I didnt see the database type. Anywa... I am afraid... there is any thing like database link in mySql.
Re: join two tables with ip [message #353221 is a reply to message #353204] Mon, 13 October 2008 00:06 Go to previous message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As previously stated, this is an Oracle forum. @roman.rule, please, search answers for your MySQL related questions elsewhere. This topic is locked.
Previous Topic: Using analytical functions
Next Topic: MIN MAX SUBQUERIES
Goto Forum:
  


Current Time: Tue Dec 06 08:30:10 CST 2016

Total time taken to generate the page: 0.10756 seconds