All pastes #73632 Raw Edit

huhlig

public text v1 · immutable
#73632 ·published 2006-06-28 02:31 UTC
rendered paste body
SELECT 
   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