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

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