Hi guys,

I have 2 tables in sql server.

Sales,Storedetails

** In VFp I would write
select sum(sales.qty),sum(sales.dollarvalue),storedetails.name,sales.store;
from sales,storedetails;
where sales.store = storedetails.store;
group by sales.store

If I try the same syntax in SQL-Server I get an error..
Storedetails is not involved in an aggregate.. How do I get around this problem in SQL - Server..