Chris heeft geschreven in bericht <7asl7q$7jt$1_at_news8.svr.pol.co.uk>...
>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;
>
>Re:You are trying to compare a name to a number! No wonder the result is
false.
Yous should start reading about using subqueries and the 'Having' clause.
>
Received on Wed Feb 24 1999 - 09:17:39 CST
