I have one query
Which is a join of table A and Table B.
select store,sum(amt) from table A and table B where
A.fld1 = B.fld1
A.fld2 = B.fld2
A.fld3 = b.fld3
AND A.fld3 between date range
group by Store
order by store.
I need to run this query in a batch mode,just by changing the date range.how can i run this query in WRKQRY Tool.
iam doing now in STRSQL which runs intercativley for an hour.
So i wanted to run in batch and saev the result sets in one file.