3 queries, the 2nd one is "right"
SELECT DISTINCT t.meter, contacts.METER, contacts.code
FROM t INNER JOIN contacts ON t.meter = contacts.METER;
18601 records
SELECT DISTINCT t.meter, contacts.METER
FROM t INNER JOIN contacts ON t.meter = contacts.METER;
11434 records
SELECT t.meter, contacts.METER
FROM t INNER JOIN contacts ON t.meter = contacts.METER;
18614 records
Why does displaying the code in the first query return more records ?
I thought "distinct" worked on the field just after "distinct"
The second query is the "right" one, and gives me set I need; but I also need to see the codes !