Is there a way to do a multi-database select query??.. I fail to find the related solution... currently i i created seperate table call stockmaster under seperate database for each seperate organizations... When i want to queries out the stock item qty for multi database, i face a problem where sql only can work for single database..
How can i use the same SQL statement in Pgsql??.. "SELECT * FROM A.stockmaster,B.stockmaster where A.item=B.item"
Regards, Ching
_________________________________________________________________ Are you in love? Find a date on MSN Personals http://match.msn.com.my/
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])