Skip to Content
0
Jan 13, 2020 at 08:53 PM

How to determine products that have not been sold since a given date

397 Views

We are trying to list all products put in the system before a certain date but which have not been sold since a second date.

I tried to link our products table to our invoice detail table and then search for nulls from invoice detail (that is, the product exists but hasn't been sold). That's not working and I'm a little lost as to what to try next. Has anyone got a suggestion?

Thanks.