Hello,

I have a table ( tblhosting )

Column Contains:

|   Id  |  Userid  |  Orderid  |  startdate  |  Termination_Date  |  ProductStatus  |

So far I have queried

1. A total number of active products from January 2016 to December 2019 in query table

2. A total number of terminated products from year January 2016 to December 2019 in another query table

How do I join them ?

It comes to the problem when I join the two queried table. Such that

Example:

in March 2019,

Total count(product ordered) is 200

Total count(terminated) product is 15

So it will be 200-15 = 185 active products. (Which is wrong)

So, I created a chart, make formula:

( Total still active product / Total terminated product ) x 100

But then, the terminated product of 15 is a product that terminated and is also activated within that month.

It should be more than 15, such that, maybe on February 2019 or previously, there is a product terminated on March 2019.

Use case:

|   Id  |  Userid  |  Orderid  |    startdate   |  Termination_Date  |  ProductStatus  |

|  123 |  424      |    2121      | 14-02-2019  |    1-02-2019             |     Terminated    |

I hope my issue statement is clear and do comes up with solution. Thanks!