select statement?

[somersbar]

i have a table with a list of films showing at a particular time, on a
particular day. some films show more than once in that day. how can i
get what films are showing that day, without getting the multiple
occurrences of films that day? i.e. no repeated values.

 

[MGFoster]

i have a table with a list of films showing at a particular time, on a
particular day. some films show more than once in that day. how can i
get what films are showing that day, without getting the multiple
occurrences of films that day? i.e. no repeated values.

SELECT DISTINCT film_name
FROM table_name

 

[somersbar]

fixed it. needed the GROUP BY statement.

thanks anyway MG.