Hi, > SELECT product, price * 1.22 AS price_with_vat > WHERE price_with_vat < 1000;
mysql> select price * 1.22 as pricevat from pricelist; +----------+ | pricevat | +----------+ | 12.81 | +----------+ 1 row in set (0.02 sec) mysql> select price * 1.22 as pricevat from pricelist having pricevat < 10; Empty set (0.00 sec) mysql> select price * 1.22 as pricevat from pricelist having pricevat > 10; +----------+ | pricevat | +----------+ | 12.81 | +----------+ 1 row in set (0.00 sec) Regards, Sasa »mysql, select, database« --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
