http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
I'd translate it to your example, but it's bed-time here in England! HTH, James Harvard At 11:42 pm +0000 5/1/06, Terry Spencer wrote: >I have a question for clearer brains than mine. I would like to join two >tables,. There may be many possible joins in table B to table A, but I only >want to join one row from B to table A - the row with the closest, but >lesser date. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
