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

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

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

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

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

What is new features in Javascript ES2020 ECMAScript 2020

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.