Dear Sir/Miss,
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/