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

2002-09-13 Thread Marek Kilimajer
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

2002-09-12 Thread Jay Blanchard
[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

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

2002-09-12 Thread Merritt, Dave
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. The problem I'm having is that the history table being called in