Here is my query:
At the base the complaint is more complex but I simplify for understanding and oversimplification. Basically, this query is supposed to return me the project (it is a number corresponding to the number of months), all grouped by idCompany and the maximum date. I'm the most recent project for a corporation.Code:SELECT idCompany project, max (date) FROM 'db_prospect_client' . 'prospect_appeal' WHERE project <> 'no' GROUP BY idCompany
Big problem: it includes by Company, it selects the last but the project number is not that corresponding to the most recent date. How to match the most recent date and project that is linked?
I hope I was clear because it is sometimes hard to explain!
Bookmarks