Re: To Re-write complex query with JOINS

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

Re: 4.1.1 not an update or upgrade of 4.1.0

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