Re: Combining two tables MYSQL

["Dan Bracuk" <webforumsuser@xxxxxxxxxxxxxx>]

Instead of a working table, use a subquery.  Something like this.

 select somefields
 from sometables
 join (select somefields, max(somedatefield) maxdate
 from sometables
 where whatever
 group by somefields ) xyz on somedatefield = maxdate
 where whatever