-- we are going to add return reason in orders tables, this will show all colums from orders and all columns from returns -- this will show all data which is matching, and neglect the null value ...

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 ...