LEFT JOIN only first row

by

If you can assume that artist IDs increment over time, then the MIN(artist_id) will be the earliest.

So try something like this (untested…)

SELECT *
  FROM feeds f
  LEFT JOIN artists a ON a.artist_id = (
    SELECT
      MIN(fa.artist_id) a_id
    FROM feeds_artists fa 
    WHERE fa.feed_id = f.feed_id
  ) a

More Related Contents:

  1. How to use mysql JOIN without ON condition?
  2. left join query keep a column empty
  3. How can I select data from different tables?
  4. SQL select only rows with max value on a column [duplicate]
  5. Join between tables in two different databases?
  6. Left Join not returning all rows
  7. MySQL JOIN ON vs USING?
  8. Required to join 2 tables with their FKs in a 3rd table
  9. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  10. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  11. When to use STRAIGHT_JOIN with MySQL
  12. MySQL JOIN the most recent row only?
  13. Difference in MySQL JOIN vs LEFT JOIN
  14. mysql query show multiple tables from one ID column
  15. How to find non-existing data from another Table by JOIN?
  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. Delete from one table with join
  27. When to use a left outer join?
  28. In what order are MySQL JOINs evaluated?
  29. MySQL cartesian product between two SELECT statements
  30. MySQL Multiple Joins in one query?

Leave a Comment