left join query keep a column empty

by

You can use GROUP BY keyword for grouping them, your query will become something like this 

  SELECT pm.receiptID
      , pm.recievedAmount
      , pd.invono
      , pd.paidAmount 
 FROM PaymentMaster pm LEFT JOIN PaymentDetail pd ON pd.receiptID = pm.receiptID GROUP BY pd.receiptID

More Related Contents:

  1. How can I select data from different tables?
  2. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  3. How can I do three table JOINs in an UPDATE query?
  4. MySQL: Quick breakdown of the types of joins [duplicate]
  5. Join between tables in two different databases?
  6. MySQL JOIN ON vs USING?
  7. Required to join 2 tables with their FKs in a 3rd table
  8. MySQL join with where clause
  9. CROSS/OUTER APPLY in MySQL
  10. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  11. MySql Count cannot show 0 values
  12. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  13. MySQL JOIN the most recent row only?
  14. mysql query show multiple tables from one ID column
  15. LEFT JOIN only first row
  16. MySQL JOIN with LIMIT 1 on joined table
  17. MySQL Inner Join Query Multiple Tables
  18. Difference between these two joining table approaches?
  19. Laravel join with 3 Tables
  20. MySQL Insert & Joins
  21. How to join two tables using a comma-separated-list in the join field
  22. MySQL LEFT JOIN 3 tables
  23. What is the default MySQL JOIN behaviour, INNER or OUTER?
  24. MySQL Join Where Not Exists
  25. how to use a like with a join in sql?
  26. When to use a left outer join?
  27. In what order are MySQL JOINs evaluated?
  28. How to store a one to many relation in MySQL database?
  29. MySQL cartesian product between two SELECT statements
  30. MySQL Multiple Joins in one query?

Leave a Comment