To Re-write complex query with JOINS

2004-01-19 Thread Vijay Patel
Hello friends, I have a problem with one of the JOIN query here. Below is a brief description of the problem. tablename : test RecordId EffectiveDate othertableidvalue - - 1 2004-01-10 1 10 2

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