Re: HELP new to sql min query

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Tue, 23 Feb 1999 10:57:12 +0000
Message-ID: <36D28987.2F4AA2DF@capgemini.co.uk>

Is this what your after :

select cname from cust, rental
where (milesin - milesout) in (select min(milesin - milesout) from rental);

Just one of many methods.

Chris wrote:

> I am trying to return the name value from one table where it equals a min
> amout in another code below but it always come back no rows selected can
> anyone help as i am new to sql
>
> select cname from cust, rental
> where cname in (select min(milesin - milesout) from rental;
Received on Tue Feb 23 1999 - 04:57:12 CST