huhlig

SELECT si.store, st.sales883+st.sales887 AS Sales, st.sales883+st.sales887/st.budget AS pct_to_budget, st.budget
FROM SalesTable AS st, DateListing AS dt, StoreInformation AS 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 dt.date=[?] And si.EMT=[?]
ORDER BY si.store;