Kevin Goosen's questions

如何将当前日期放入 where 子句而不必一直输入？

Select SALEITEMS.SKU,
       STOCK.SHORTDESC,
       SALEITEMS.SALEPRICEEX,                    
       SALEITEMS.COSTPRICEEX,
       SUM(((SALEITEMS.SALEPRICEEX - SALEITEMS.COSTPRICEEX) / 
             SALEITEMS.SALEPRICEEX) * 100) AS GP    
  From SALEITEMS
 Inner Join STOCK On SALEITEMS.SKU = STOCK.SKU 
 where SALEITEMS.FP_DATE = '13 Nov 2018'
 group by 1,2,3,4