KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Seemingly simple MySQL question, but I've never had to do this before.. I have two tables, items and prices, with a one-to-many relationship. Items Table id, name Prices Table id, item_id, price Where prices.item_id = items.id What I have so far: SELECT items.id, items.name, MIN(prices.price) FROM items LEFT JOIN prices ON items.id = prices.item_id GROUP BY items.id How do I also return the corresponding prices.id for that minimum price? Thanks!
Tags (comma-separated)
Save Edits
Cancel