I am new in SQL language and wanted to know if anyone can help with deleting a product based on the criteria that I have, I want the query to look at the product code, and product name if the complete date is equal to the harvest date I want the query to delete line item.I hope this makes since.
"if the complete date is equal to the harvest date I want the query to delete line item". Based on the data, it looks you mean the complete date from one row matches the harvest date for a different row (but only for same Code). If so, then "delete the item", which one? The row with the matching complete date or harvest date? Or both of them??