Adding Storedetails.name to the group by should do it.

>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..