2017-11-09, 10:34
(2017-08-30, 12:58)PH-SYM Wrote: Works great.
BTW, is there a specific reason for using "SELECT DISTINCT" instead of just "SELECT"? Just to check whether I understand it correctly, it will filter out duplicate movies won't it?
You can use "SELECT DISTINCT" for all cases, but it's not always needed. It's needed if you e.g. multiple linked tables like "show my all movies that have video codec x264 or audio codec mp3". In this case a movie can by listed for case one and case two.
