[PHP] multiple db, multiple table join

Good evening all, I have a strange situation which I cannot think myself out of. To make it simple my db looks like this (hr db, emp_master table) ++---+ | emp_id | last_name | ++---+ | 1 | smith | | 3 | wesson| |

Re: [PHP] multiple db, multiple table join

This really isn't a PHP question at all. Anyway, you just need to give nicknames to multiple instances of the same table (here I use e1 and e2). Something like... select order_id, e1.last_name, e2.last_name from tools.orders, hr.emp_master e1, hr.emp_master e2 where