WM3hVPaM

1CREATE TEMPORARY TABLE IF NOT EXISTS StoreRev (Stores nvarchar(44));
2TRUNCATE TABLE StoreRev;
3INSERT INTO StoreRev SELECT StoreId FROM MDC_Customer WHERE StoreId IN ('00013');
4CREATE TEMPORARY TABLE IF NOT EXISTS CaixaRev (CaixaID int, StoreID char(20));
5TRUNCATE TABLE CaixaRev;
6INSERT INTO CaixaRev SELECT CaixaId, StoreId FROM MDC_Caixa CX WHERE CAST(CX.Data AS date) BETWEEN '2018-05-01' AND '2018-05-01' AND CX.StoreID IN (SELECT StoreID FROM StoreRev);
7SELECT * FROM StoreRev;
8SELECT * FROM CaixaRev;
9DROP TEMPORARY TABLE StoreRev;
10DROP TEMPORARY TABLE CaixaRev;