On Wednesday 26 September 2001 16:34, you wrote:
> Howdy list!
> Nesting doesn't seem to work either:
> SELECT P_CODE, P_DESCRIPT, PRICE
> FROM INVENTRY
> WHERE PRICE = (SELECT MAX(PRICE))
> FROM INVENTRY);
>
> - syntax error
> This is really weird. Why do You think it c
Tobias Bohlin writes:
> Get in trouble with:
> SELECT COUNT (DISTINCT V_CODE) FROM INVENTRY;
> - SYNTAX ERROR
Two errors in your query: MySQL doesn't allow you to
insert whitespace between the function name and the
parentheses, and you've misspelled inventory. :-o
//C
--
Carl Troein - Círda
