Re: [PHP] OT - SQL string to get value by latest date only in a join

Add ORDER BY date_col DESC LIMIT 1 Merritt, Dave wrote: >All, > >I apologize up front for being off topic, but I don't want to have to >subscribe to other lists unless necessary. I know that someone on this list >should be able to help me out. > >I have the SQL string below that I am running.

RE: [PHP] OT - SQL string to get value by latest date only in a join

[snip] SELECT customer.customer_id, customer.customer_name, business_unit.business_unit, customer.created_date, CONCAT_WS(", ", username.last_name, username.first_name), history.modify_date, CONCAT_WS(", ", modified.last_name, modified.first_name), history.description FROM `customer` LEFT OUTER JO