SQL SELECT from multiple tables

by 
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

More Related Contents:

  1. Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]
  2. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  3. How can I do a FULL OUTER JOIN in MySQL?
  4. SQL update from one Table to another based on a ID match
  5. SQL join: selecting the last records in a one-to-many relationship
  6. SQL to LINQ with multiple join, count and left join
  7. Difference between left join and right join in SQL Server [duplicate]
  8. Oracle “(+)” Operator
  9. JOIN two SELECT statement results
  10. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  11. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  12. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  13. How do I UPDATE from a SELECT in SQL Server?
  14. Explicit vs implicit SQL joins
  15. Select rows which are not present in other table
  16. Does the join order matter in SQL?
  17. What is the difference between JOIN and UNION?
  18. Left Outer Join Not Working?
  19. Inner Join vs Natural Join vs USING clause: are there any advantages?
  20. Including null values in an Apache Spark Join
  21. How to kill a running SELECT statement
  22. Why postgres returns unordered data in select query, after updation of row?
  23. How do I convert a “legacy” left outer join statement in Oracle?
  24. MySQL: GROUP_CONCAT with LEFT JOIN
  25. Joining multiple tables in SQL
  26. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  27. sql sum data from multiple tables
  28. IN vs. JOIN with large rowsets
  29. SQL: Two select statements in one query
  30. SQL Inner Join On Null Values

Leave a Comment