huhlig
public text v1 · immutableSELECT
store,
sum([SalesTable].[sales883], ([SalesTable].[sales887]),
sum([SalesTable].[sales883], ([SalesTable].[sales887])/budget,
budget
FROM
SalesTable st,
DateListing dt,
StoreInformation si
WHERE
st.store=si.store AND
dt.year=st.year AND
dt.quarter=st.quarter AND
dt.period=st.period AND
dt.week=st.week AND
st.store = ? AND
dt.date = ?
ORDER BY
store