The below works!!! I am investigating if it covers everything, but looks
good!
Thanks a mill!!!!
On 4 May 2012 12:12, Oliveiros d'Azevedo Cristina <
oliveiros(dot)cristina(at)marktest(dot)pt> wrote:
> SELECT *
> FROM
> (
> SELECT petname,SUM(quantity) as total
> FROM pets a
> NATURAL JOIN sales b
> GROUP BY petname
> ) x
> NATURAL JOIN
> (SELECT MIN(total) as total
> FROM
> (
> SELECT petname,SUM(quantity) as total
> FROM pets a
> NATURAL JOIN sales b
> GROUP BY petname
> )y
> )z
>