Changes between Version 1 and Version 2 of View3


Ignore:
Timestamp:
08/21/26 08:54:21 (25 hours ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • View3

    v1 v2  
    4242==== Logic explanation
    4343**1.** The store information is retrieved from `store`.
     44
    4445**2.** The `report` table provides the monthly profit and overall profit.
     46
    4547**3.** The `exchanges_data` table provides monthly profit, sales, and damages.
     48
    4649**4.** LEFT JOIN is used for `exchanges_data` so that a report is still displayed even if no corresponding data exchange record exists.
     50
    4751**5.** Each row represents the financial information for a particular store and reporting date.
    4852