Need some help here. I have created an individual query for each product which works absolutely fine.
However i want to be able to join it so i can display on my page who is due for a review.
SELECT clients.*, protection.* FROM (clients JOIN protection ON protection.clients_ClientID=clients.ClientID) WHERE ReviewDate >= CURRENT_DATE() AND ReviewDate <= DATE_ADD(CURRENT_DATE(),INTERVAL 7 DAY) OR ReviewDate <= CURRENT_DATE()
This works great but i do not want to show on my page 8 queries that are the same is this except the protection is maybe mortgage.
could anyone help me make this into one query for all product tables?
They all have same reviewdate column.
No idea how to join multiple queries.