Mysql query to retrive data from join of three table [duplicate]

by 

select *
from persons p join quantity q on p.id = q.people_id
join books b on q.product_id = b.id

More Related Contents:

  1. SELECT POPULAR POST
  2. How to filter SQL results in a has-many-through relation
  3. Return row only if value doesn’t exist
  4. How to fix: “No suitable driver found for jdbc:mysql://localhost/dbname” error when using pools? [duplicate]
  5. UTF-8: General? Bin? Unicode?
  6. Transposing Dynamic Columns to Rows
  7. Are nested transactions allowed in MySQL?
  8. LOAD DATA INFILE easily convert YYYYMMDD to YYYY-MM-DD?
  9. MyIsam engine transaction support
  10. When to use SELECT … FOR UPDATE?
  11. BULK INSERT in MYSQL
  12. Setting column values as column names in the SQL query result
  13. Count table rows
  14. MYSQL sum() for distinct rows
  15. Implementing a hierarchical data structure in a database
  16. How to lock a single row
  17. MySQL Cannot drop index needed in a foreign key constraint
  18. How to get current date & time in MySQL?
  19. Laravel join with 3 Tables
  20. MySQL Insert & Joins
  21. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  22. How to join two tables using a comma-separated-list in the join field
  23. How do I split the output from mysqldump into smaller files?
  24. How to regex in a MySQL query
  25. How to remove duplicate entries from a mysql db?
  26. Syntax error on MERGE statement
  27. How do you force mysql LIKE to be case sensitive? [duplicate]
  28. MySQL Alter table causes Error: Invalid use of NULL value
  29. Delete all rows with timestamp older than x days
  30. In what order are MySQL JOINs evaluated?

Leave a Comment