select * from supplier
where supidx in
(   select supidx
     FROM
       ( select max(gltd) as TranDate,supidx
        from apthdr              
        group by supidx
       )AS Tran
     WHERE Convert(varchar(10),Tran.TranDate,120) <            Convert(varchar(10),"01/07/2009",120)
)

No grouping is required for outer query

try individual select queries from the whole query

whats you backend? Sql server or oracle or MySQL?

I assumed it is Sql server.

May be some problem here

select * from supplier
where supidx in
(   select supidx
     FROM
       ( select max(gltd) as TranDate,supidx
        from apthdr              
        group by supidx
       )AS Tran
     WHERE Convert(varchar(10),Tran.TranDate,120) <            Convert(varchar(10),"01/07/2009",120)
)

Tran is a keyword, change it to mytable

Edited by Jyothi Yepuri - 07 Sep 2009 at 6:34pm

then try changing the date conversion in where condition as

TO_DATE (Mytable.TranDate , 'DD-MM-YYYY') = TO_DATE ('01/07/2009', 'DD-MM-YYYY')