select statement?

S

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.
 
M

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
 
Top