Sales

Dear all,

can someone assist me with a query to display total sales quantity for two whses on two different columns for a specified range of dates. Basically what i want to achieve is:

Firmname [column]

Whse code 1 Total quantity sold [column]

Whse code 2 Total quantity sold [column]

if someone has such a query please assist me with it.

Regards.