Starting to hate SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Starting to hate SQL

Author

Topic

MikeB
Constraint Violating Yak Guru

387 Posts

Posted - 2002-07-04 : 10:45:02

I am trying to group by ShippingDate, ProjectNumber, LoadNumber, Stack, Level in the following SQL Statement:


csSelect.Format("SELECT ShippingLoadTable.ShippingDate,
                        ShippingLoadTable.ProjectNumber,
                        ShippingLoadTable.LoadNumber,
                        ShippingLoadTable.MarkNumber,
                        [ShippingLoadTable.Stack],
                        [ShippingLoadTable.Level],
                        [ShippingLoadTable.Position]
                 FROM ShippingLoadTable WHERE ShippingLoadTable.ShippingDate = #%s#
                    AND ProjectNumber = '%s'
                 GROUP BY ShippingLoadTable.ShippingDate,
                          ShippingLoadTable.ProjectNumber,
                          ShippingLoadTable.LoadNumber,
                          ShippingLoadTable.Stack,
                          ShippingLoadTable.Level",
                 csDate, m_csProjectNumber);

I get the following error:

"You tried to execute a query that does not include the specified expression 'LoadNumber' as part of an aggregate function." (1)}

What does this mean?

Mike B

Edited by - MikeB on 07/04/2002 10:48:24

Edited by - MikeB on 07/04/2002 10:49:04

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2002-07-04 : 10:55:18

As I said in the other post, you have to include all the values in your Select list in a Group by....

Peace

Rick