NYCPHP Meetup

[Kshitij Bedi]

Hi there

can someone tell me why this query below is not working in mysql 4.0.16 
its a select within a select query. If this syntax below is not correct, is
there a work around for this.

Considering tblA has alot of fields including ID(Primary Key) and ID1 as
another field

Query:
Select * from tblA where id in (select max(id) from tblA where id>=76 and
id<=109 group by id1)

Regards,
Kshitij Bedi
Web Admin
International Trademark Association