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