I'm doing a package tracking feature for the website of a delivery service out here. I'm trying to perform an inner join based on the success of an if statement in my sql query.

SELECT Customers.Name, Orders.Product FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID; SELECT Customers.Name, Orders.Product FROM Customers LEFT JOIN Orders ON ...