SQL Select overload?

[Ruslan Zasukhin]

on 1/8/04 6:34 AM, Tim Davis at timdavis at amug.org wrote:

> Hi Ruslan,
> 
>   I created a query with a join between 2 tables and over 2 dozen
> fields. All the fields came back, but the values of the parent table
> did not. When I split and shortened the SQL select statement all the
> data came back fine. See actual examples below. Is this an overloaded
> query due to the length, or am I retrieving the parent fields wrong?

Hi Tim,

IF you use SUM() you already cannot use normal fields in SELECT.

This is standard rule.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------