i am trying to write a query where i am trying to get a result like this.
locationid storeid date time totalin totalout
1234 abc 12/01/2011 11 5 2
1234 abc 12/01/2011 16 4 1
i am attaching my data how it is store in.
can someone help me out.