Get a list of unique molecules that match the input condition

Need help Database
1

I’m having difficulty with this issue,
I have 2 data tables and “Product” and “Item”.
The "Item " table will contain “Product”.
For example:
table Product:

  • Id: 1, Name: Product1
  • Id: 2 Name: Product2
  • Id: 3 Name: Product3

table Item :

  • Id: 1, Name: Item1, Product: Product1
  • Id: 2, Name: Item2, Product: Product1
  • Id: 3, Name: Item3, Product: Product2
  • Id: 4, Name: Item4, Product: Product3
  • Id: 5, Name: Item5, Product: Product3

Do I want a list of “Items” when the condition is Product1 and Product3 like:
Result “Item”:

  • Id: 1, Name: Item1, Product: Product1
  • Id: 5, Name: Item5, Product: Product3
    Or :
  • Id: 1, Name: Item1, Product: Product1
  • Id: 4, Name: Item4, Product: Product3

As long as you get 1 record when the conditions are met.

Hope everybody help please!
Thank you!