SELECT DISTINCT & SELECT in SQL

[Guest]

I have a query that I want to select all the unique records in one field, and
show all fields for those records.

The SQL Im trying to use is...

SELECT [Emp# Field],[Date Field],[O Field], [MinWorked]
SELECT DISTINCT [I Field]
FROM punch5duplicates;

That is returning a syntax error.
Thanks in advance for the help.
DS

 

[Michel Walsh]

Hi,



You can't have two SELECT main clauses.


SELECT f1, LAST(f2), LAST(f3), LAST(f4)
FROM myTable
GROUP BY f1



would display f1 without repetition, and list ONE (random) record (fields
f2, f3, f4) associated to each f1 value.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

That is perfect, Thank you!

Hi,



You can't have two SELECT main clauses.


SELECT f1, LAST(f2), LAST(f3), LAST(f4)
FROM myTable
GROUP BY f1



would display f1 without repetition, and list ONE (random) record (fields
f2, f3, f4) associated to each f1 value.



Hoping it may help,
Vanderghast, Access MVP

I have a query that I want to select all the unique records in one field,
and
show all fields for those records.

The SQL Im trying to use is...

SELECT [Emp# Field],[Date Field],[O Field], [MinWorked]
SELECT DISTINCT [I Field]
FROM punch5duplicates;

That is returning a syntax error.
Thanks in advance for the help.
DS