How to make a request to select one record?

Question

MySQL

Hello everyone,
There are tables
categories
id,
name
--------------
items
id
category_id
name
So each category can have up to N number of item
I don’t understand how to put limit in join
The essence is this
I need select, for example, by where in (categories_ids) from the items table, one entry for each category, or to be more precise, for the last one.
Who faced? or who knows the solution?
Thanks

Answer 1

If I understand correctly, then like this
sqlfiddle.com/#!9/180f22/46

Answer 2

instead of join use outer apply.
outer apply (select top 1 * from table t where t.category = outercategory ) qwerty