Re: Video Shop SQL problem

From: Jeremy Russell <jeremyr_at_techie.com>
Date: Sun, 03 May 1998 11:31:37 GMT
Message-ID: <354c554f.3393342@news.dircon.co.uk>

steelx_at_hotmail.com wrote:

>I'm new to SQL and Oracle. I'm currently practising my SQL by modelling a
>fictitious video shop, and I hope someone out there will help me with the
>following problem.
>

<table layouts snipped>

>Is there any way to find out which films are purchased by all buyers using
>SQL?
Sure there is - but if you clarify the question a little, it would help. Do you want films purchased by any buyers? Only films where ALL buyers have purchased a copy? Or something else ...

Jeremy Received on Sun May 03 1998 - 06:31:37 CDT