MySQL Inner Join Query Multiple Tables

by

Try this:

SELECT 
  p.id,
  p.name,
  l.url,
  o.user_id,
  o.pricing_id
FROM orders AS o
INNER JOIN products_pricing AS pp ON o.pricing_id  = pp.id
INNER JOIN products         AS  p ON pp.product_id = p.id
INNER JOIN listings         AS  l ON l.user_id = o.user_id
WHERE o.user_id ='7' 
  AND l.id = 233 
  AND l.url="test.com";

SQL Fiddle Demo

For the sample data you posted in your question, this will give you:

| ID |        NAME |      URL | USER_ID | PRICING_ID |
------------------------------------------------------
| 33 | testproduct | test.com |       7 |         37 |

More Related Contents:

  1. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  2. 1052: Column ‘id’ in field list is ambiguous
  3. Join tables with SUM issue in MYSQL
  4. Join between tables in two different databases?
  5. Required to join 2 tables with their FKs in a 3rd table
  6. How can I join multiple SQL tables using the IDs?
  7. Why does MySQL report a syntax error on FULL OUTER JOIN?
  8. Mixing ANSI 1992 JOINs and COMMAs in a query
  9. Cumulative sum over a set of rows in mysql
  10. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  11. MySQL JOIN the most recent row only?
  12. How to find non-existing data from another Table by JOIN?
  13. Difference between these two joining table approaches?
  14. Laravel join with 3 Tables
  15. MySQL LEFT JOIN 3 tables
  16. how to use a like with a join in sql?
  17. When to use a left outer join?
  18. In what order are MySQL JOINs evaluated?
  19. How to store a one to many relation in MySQL database?
  20. MySQL Multiple Joins in one query?
  21. MySQL – Get row number on select
  22. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  23. Operand Should Contain 1 Column – MySQL NOT IN
  24. Best practices for SQL varchar column length [closed]
  25. SELECT query return 1 row from each group
  26. MySQL Group By Hours
  27. RMySQL dbWriteTable with field.types
  28. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  29. MySQL update statement to store ranking positions
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment