Query Problem Please Help

2002-02-02 Thread Victoria Reznichenko
Amit, Saturday, February 02, 2002, 3:10:01 PM, you wrote: ADL> I am trying to fire the following query but it is generating an error:- ADL> select color from colortable where colorcode = select max(colorcode) from ADL> colortable where colorcode <= 5 Have a look at: http://www.mysql.com/d

Re: Query Problem Please Help

2002-02-02 Thread Joseph Bueno
Amit Dilip Lonkar a écrit : > > I am trying to fire the following query but it is generating an error:- > > select color from colortable where colorcode = select max(colorcode) from colortable >where colorcode <= 5 > > Please Help > > Thanks > Amit Lonkar > >

Query Problem Please Help

2002-02-02 Thread Amit Dilip Lonkar
I am trying to fire the following query but it is generating an error:- select color from colortable where colorcode = select max(colorcode) from colortable where colorcode <= 5 Please Help Thanks Amit Lonkar - Bef