Page 1 of 1

making a join on a a diffrent DB

Posted: Mon Mar 14, 2005 7:21 am
by pelegk2
i have 2 db
when i make a simple query like :
SELECT * from order_header. common.clients where common.clients.client_id=order_header.client_id and order_header.del_id=9876
but when i want to do a JOIN :
SELECT * from order_header
LEFT JOIN common.clients On common.clients.client_id=order_header.LAKOACH
where order_header.del_id=9876
it dosent let me ! why?

Posted: Mon Mar 14, 2005 7:34 am
by infolock
this may be of some good help to you :
http://dev.mysql.com/doc/mysql/en/left- ... ation.html

anyways, try this :

Code: Select all

SELECT * from order_header 
LEFT JOIN common.clients On (common.clients.client_id=order_header.LAKOACH) 
where order_header.del_id=9876