Hi!

storedetails.name fields have no menaing in VFP too, they can return incorrect values. This is because how you determine which record should be used to return these values from the set of records used by sum()? You require to group also by a name field:

select sum(sales.qty),sum(sales.dollarvalue),storedetails.name,sales.store
from sales,storedetails
where sales.store = storedetails.store
group by sales.store, storedetails.name

In addition, if there are more than one record in storedetails for sales, you will get incorrcet sum because record repeating from stores table. Select sum first, than get the names in such case:

select a.*, storedetails.name
  from (
    select sum(sales.qty),sum(sales.dollarvalue),sales.store
      from sales
      group by sales.store
    ) a,storedetails
  where sales.store = storedetails.store

HTH.

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