On 11 May 2006 at 7:39, majstoru wrote:

>Thanks for your reply, but can you please write an SQL how to solve
>this, I'm very poor with CASE into SQL statement?

SELECT CASE A.Group WHEN 1 THEN A.Price WHEN 2 THEN C.Price WHEN 3
THEN A.Price * P.Param_price END as Price
FROM Article JOIN Catalog C ON C.Article =
A.id JOIN Param P ON P.Date=A.Date
WHERE Id = :ID

--
SY, Dimitry Sibiryakov.