General information
Forum:
Microsoft SQL Server
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..
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only