I have a SQL where clause question that I hope you can help me with. I am trying to filter the results of my product database query to not retrieve specified products types where the stock received date is greater than the 01/10/19, if the products types are in the database with another date that is less than 01/10/19 then it should also be included in the results.

In the example below I don't want the SQL to display any products with the product type "446" that has a product received date that is >= 01/10/2019. So the milk product with the batch number "AE0152" I don't want to be included in the results but the milk product with the batch number "AE0142" I do.

I hope this makes sense. I have tried to a few different combinations but nothing seems to work.

Any help would be greatly appreciated.
Thanks

```
Product No:     Product Description:    Product Type:   Product received date:  Batch Number:
00001441        Milk                    446              30/09/2019             AE0142
00001441        Eggs                    446              15/10/2019             AE0151
00001441        Milk                    446              04/10/2019             AE0152
00001441        Flour                   450              08/10/2019             AE0201
00001441        Sugar                   450              08/10/2019             AE0201
00001441        800g White loaf         500              14/10/2019             AE0232

```