September 07, 2008, 13:54:34 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Add your links to our directory. Click here to add your links.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Add your links to our directory. Click here to add your links.
IT Resources
Pages: [1]
« previous next »
  Print  
Author Topic:

New in sql commands

 (Read 914 times)
0 Members and 1 Guest are viewing this topic.
ToBad
Jr. Member
**

Points: 0
Offline Offline

Posts: 20
« on: June 07, 2006, 13:22:24 »
Hi,

 I'm quite new in database and I need a tip/advice: How can I do a select on 2 databasese in the same time ?

Logged
Expect the worst, it's the least you can do.


xulescu
Full Member
***

Points: 8
Offline Offline

Posts: 245


WWW
« Reply #1 on: June 07, 2006, 13:27:24 »
on 2 databases or 2 tables ?

from 2 databases and 2 tables is quite simple:

select * from db1.tb1 left join db2.tb2 on db1.tb1.id=db2.tb2.id

Regards
Logged
Tracking Deleted Domains, Link Popularity and more ...
sintex
Jr. Member
**

Points: 7
Offline Offline

Posts: 96
« Reply #2 on: June 08, 2006, 15:56:35 »
A more simple ex is:

select d1.*,d2.* from db1.t1 as d1 , db2.t2 as d2
Logged
ToBad
Jr. Member
**

Points: 0
Offline Offline

Posts: 20
« Reply #3 on: June 08, 2006, 16:04:01 »
Thanks guy's
Logged
Expect the worst, it's the least you can do.
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks
TinyPortal v0.9.7 © Bloc 		Valid XHTML 1.0! Valid CSS!