Re: 4.1.1 not an update or upgrade of 4.1.0

2004-01-19 Thread Aman [System Support]
Hi, I also faced this kind of error in sub query, any solution for this?: -Aman. On Mon, 19 Jan 2004, Director General: NEFACOMP wrote: > Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1 > When the SUB-SELECT contains more than one field, it does not work (this works

Re: To Re-write complex query with JOINS

2004-01-19 Thread Aman [System Support]
hi vijay, You can use order by & group by commands in the queries.. Thanks and Regs, - Aman. On Mon, 19 Jan 2004, Vijay Patel wrote: > Hello friends, > > I have a problem with one of the JOIN query here. > Below is a brief description of the problem. > > tablename : test > > RecordId Ef