SQL SELECT from multiple tables
SELECT p.pid, p.cid, p.pname, c1.name1, c2.name2FROM product pLEFT JOIN customer1 c1 ON p.cid = c1.cidLEFT JOIN customer2 c2 ON p.cid = c2.cid
SELECT pid, cid, pname, name1, name2 FROM customer1 c1, product p WHERE p.cid=c1.cid UNION SELECT pid, cid, pname, name1, name2 FROM customer2 c2, product p WHERE p.cid=c2.cid;
SELECT `product`.*, `customer1`.`name1`, `customer2`.`name2`FROM `product`LEFT JOIN `customer1` ON `product`.`cid` = `customer1`.`cid`LEFT JOIN `customer2` ON `product`.`cid` = `customer2`.`cid`