Ive got two tables that look like this:
Customer Infomation:
Rent Infomation:
I want to show all the details of the customer table, but only display the customers that are currently renting.
Ive tried but haven’t had any success with the sql.
>Solution :
I think you may be looking at possibly just a simple inner join and Where query, that is if you are able to use SQL/T-SQL.
SELECT c.CustomerID, c.CustomerName
FROM CustomerInformation c
INNER JOIN RentInformation r ON r.CustomerID = c.CustomerID
WHERE r.endDate > GetDate()