SQL Query

[sandum150]

Hello everybody!


I had created a query with follow SQL:
SELECT clienti.nume_client, tracker.id_tracker, tracker.SIM, abonamente.[data achitarii], abonamente.data_expirarii
FROM tracker INNER JOIN (clienti INNER JOIN abonamente ON clienti.[ID] = abonamente.[client]) ON tracker.[ID] = abonamente.[tracker];

But I need 2 conditions:
1. Each tracker.id_tracker should be distinct
2. abonamente.data_expirarii should be the maximum (biggest value)

That's the structure of my db

Thank You!

[rpeare]

this is a relationship diagram not a SQL statement.

If you are looking for the most recent data_expirarii for each client and showing information related to that record you have to do a 2 step query.

The easiest way to do that is to create a query that shows your client and their most recent data_expirarii first

this query will give you that:

SELECT Max(abonamente.Data_Expirarii) AS MR_Exp, abonamente.Client
FROM abonamente
GROUP BY abonamente.Client;

From there you would link this 'pre' query to your abonamente table linking on both the client and data_expirarii fields.

Assuming you only have on record in your abonamente table for each data_expirarii you should be able to get the data you want.