SQL SELECT from multiple tables

Question

How can I get all products from customers1 and customers2 include their customer names   customer1 table cid name1 1   john 2   joe  customer2 table cid name2 p1  sandy p2  linda  product table pid cid pname 1   1   phone 2   2   pencil 3   p1  pen 4   p2  paper   Result should be like this  pid  cid  pname  name1 name2 1    1    phone  john  NULL 2    2    pencil joe   NULL 3    p1   pen    NULL  sandy 4    p2   paper  NULL  linda

User · Accepted Answer

SELECT p pid  p cid  p pname  c1 name1  c2 name2 FROM product p LEFT JOIN customer1 c1 ON p cid   c1 cid LEFT JOIN customer2 c2 ON p cid   c2 cid

User · Answer

i think i hve some joined like this from 7 Tables  SELECT a no surat    a nm anggota    a nrp nip anggota    a tmpt lahir    a tgl lahir    a bln lahir    a thn lahir    a alamat    a keperluan    a nm jabatan    b id polsek  b nm polsek   c id polres  c nm polres    d id pangkat   d nm pangkat   e id pejabat   e nm pejabat    f id ket   f nm ket   g id pejabat g nm pejabat  FROM tbl skhp AS a  LEFT JOIN tbl polsek AS b ON a id polsek b id polsek  LEFT JOIN tbl polres AS c ON a id polres c id polres  LEFT JOIN tbl pangkat AS d ON a id pangkat d id pangkat LEFT JOIN tbl pejabat AS e ON a id pejabat e id pejabat LEFT JOIN tbl ket AS f ON a id ket f id ket  LEFT JOIN tbl pejabat AS g ON a id pejabat g id pejabat   i hope u understand      i am just sharing worked code for me     i am use it to fetch data to my readonly form just for priview

User · Answer

SELECT  product      customer1   name1    customer2   name2  FROM  product  LEFT JOIN  customer1  ON  product   cid     customer1   cid  LEFT JOIN  customer2  ON  product   cid     customer2   cid

User · Answer

SELECT    pid     cid     pname     name1     null  FROM    product p INNER JOIN    customer1 c ON p cid   c cid UNION SELECT    pid     cid     pname     null     name2 FROM    product p INNER JOIN    customer2 c ON p cid   c cid

User · Answer

select p pid  p cid  c1 name c2 name from product p left outer join customer1 c1 on c1 cid p cid left outer join customer2 c2 on c2 cid p cid

User · Answer

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

User · Answer

SELECT p pid  p cid  p pname  c1 name1  c2 name2 FROM product AS p     LEFT JOIN customer1 AS c1         ON p cid   c1 cid     LEFT JOIN customer2 AS c2         ON p cid   c2 cid

[sql] SQL SELECT from multiple tables

Examples related to sql

Examples related to select

Examples related to join

Examples related to left-join

Examples related to outer-join