Re: join with tabla.col=max(tablea.col)

Thanks for your reply, but my problem is not solved by your suggestions: > mysql>> select *,max(cb) from testb left join testa using (ca) group by > > testb.ca; > This query selects all the fields from testb (ca, time) AND > testa (ca, cb) because of the LEFT JOIN you used. You should > try spec

Re: join with tabla.col=max(tablea.col)

Hi, === Question No.1 === mysql>> select *,max(cb) from testb left join testa using (ca) group by > testb.ca; > +--++--+--+-+ > | ca | time | ca | cb | max(cb) | > +--++--+--+-+ > |2 | 20020705145347 |