How to list all row of a table and when join with another table is possible only the first row of it?

How to list all row of a table and when join with another table is possible only the first row of it?

I'm setting up an "order management" application which should provide a datalist listing up all my catalog item and show for each of them the "last order date". I also want the items not ordered yet to be reflecting without last order date.

I'm setting up an "order management" application which should provide a datalist listing up all my catalog item and show for each of them the "last order date". I also want the items not ordered yet to be reflecting without last order date.

I have tried this query without success

SELECT i.id, i.name, d.name 
FROM items i
JOIN LEFT orders o
ON i.id = o.items

I have these tables in my MySQL database:

ITEMS

ID|Name 
-----------
0 |Table
1 |Chair
2 |Screen
3 |Speaker
4 |Keyboard
5 |Laptop
6 |Mug

ORDERS

ID|ITEMS|DATE
-----------------
0 |  0  |20190122
1 |  0  |20181231
2 |  1  |20180601
3 |  3  |20180122
4 |  2  |20171231
5 |  4  |20180501
4 |  6  |20171115
5 |  3  |20180101

And would like the following output :

LAST_ORDER_DATE

ID|NAME    |DATE
--------------------
0 |Table   |20190122
1 |Chair   |20180601
2 |Screen  |20171231
3 |Speaker |20180122
4 |Keyboard|20180501
5 |Laptop  |
6 |Mug     |20171115

Thanks for any help

sql mysql

What's new in Bootstrap 5 and when Bootstrap 5 release date?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Random Password Generator Online

HTML Color Picker online | HEX Color Picker | RGB Color Picker

What are the differences between Standard SQL and Transact-SQL?

In this article, we'll explain syntax differences between standard SQL and the Transact-SQL language dedicated to interacting with the SQL

SQL Full Course - SQL Tutorial For Beginners - MySQL Essentials - SQL Training

This SQL Full Course video will cover all the topics of SQL starting from scratch. This video is great for beginners who want to learn SQL and for advanced people to brush up their skills.

SQL vs NoSQL or MySQL vs MongoDB

SQL vs NoSQL or MySQL vs MongoDB: SQL or NoSQL? MySQL vs MongoDB? Which database is better? Which one should you use?