Thank you answer,

But this query error too :

Select max(o.workingorder), o.ColorId,max(c.name) colorname , max(c.colorno)
colorno
from OrderColor O
join color c on (o.colorid = c.colorid)
group by o.colorid
order by o.workingorder

if like this then no error

Select max(o.workingorder), o.ColorId,max(c.name) colorname , max(c.colorno)
colorno
from OrderColor O
join color c on (o.colorid = c.colorid)
group by o.colorid
order by 1

----- Original Message -----
From: ""Robert DiFalco"" <rdifalco@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Wednesday, April 30, 2003 11:33 AM
Subject: RE: [ib-support] firebird1.5 group by question


> You are ordering on a field that is not in the list of your result set
> values.
>
> -----Original Message-----
> From: Rich Ding [mailto:ags@...]
> Sent: Tuesday, April 29, 2003 9:22 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] firebird1.5 group by question
>
>
> Hello,
> I have a question ,Please help
>
>
> TWO TABLES:
> /****************************/
> CREATE TABLE ORDERCOLOR (
> ORDERID INTEGER NOT NULL,
> COLORID INTEGER NOT NULL,
> FIXKIND SMALLINT DEFAULT 0 NOT NULL,
> SIZELEVEL VARCHAR (20),
> WORKINGORDER SMALLINT) ;
>
> ALTER TABLE ORDERCOLOR ADD PRIMARY KEY (ORDERID, COLORID,
> FIXKIND,
> SIZELEVEL);
>
> /****************************/
>
> CREATE TABLE COLOR (
> COLORID INTEGER NOT NULL,
> COLORNO VARCHAR(20) NOT NULL,
> NAME VARCHAR(40) NOT NULL,
> COLORINDEX INTEGER DEFAULT 0 NOT NULL);
>
> ALTER TABLE COLOR ADD PRIMARY KEY (COLORID);
> ALTER TABLE COLOR ADD UNIQUE (COLORNO);
>
> /****************************/
>
>
> this query on firebird1.5 result a error :
>
> Select o.ColorId,max(c.name) colorname , max(c.colorno)
> colorno
> from OrderColor O
> join color c on (o.colorid = c.colorid)
> group by o.colorid
> order by o.workingorder
>
>
> Dynamic SQL Error.
> SQL error code = -104.
> invalid column reference.
>
>
> firebird 1.02 no error .
>
>
> this query on firebird1.5 no error
>
>
> Select o.ColorId,max(c.name) colorname , max(c.colorno)
> colorno
> from OrderColor O
> join color c on (o.colorid = c.colorid)
> group by o.colorid ,o.workingorder
> order by o.workingorder
>
>
>
> what's wrong?
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=229633.3212141.4526654.2595810/D=egroupweb/S=1705
> 115386:HM/A=1556779/R=0/*http://shop.store.yahoo.com/cgi-bin/clink?ftd2+
> shopping:dmad/M=229633.3212141.4526654.2595810/D=egroupweb/S=1705115386:
> HM/A=1556779/R=1/1051676254+http://us.rmi.yahoo.com/rmi/http://www.ftd.c
> om/rmi-framed-url/http://www.ftd.com/yahoo36>
>
> <http://us.adserver.yahoo.com/l?M=229633.3212141.4526654.2595810/D=egrou
> pmail/S=:HM/A=1556779/rand=269225060>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------ Yahoo! Groups Sponsor ---------------------~-->
> Get 128 Bit SSL Encryption!
> http://us.click.yahoo.com/xaxhjB/hdqFAA/bW3JAA/67folB/TM
> ---------------------------------------------------------------------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>