Hi,
There are some ways to achieve this. One of them, we can use LeftJoin. The following will help you.
Regards,