SQL don't work

[noamway]

Hello,

Someone know why this is don't work:

SELECT detail_id, de_id, subjectTXT, urlTXT, pictureTXT, priceSaleNUM
FROM storeProductHomepageDB
WHERE de_id = 11245 AND (CASE WHEN (parentNUM = 0) THEN lan_id = 0 ELSE (lanParent_id = 0) END)
ORDER BY rootTXT

[richasaraf]

Hello,

Someone know why this is don't work:

SELECT detail_id, de_id, subjectTXT, urlTXT, pictureTXT, priceSaleNUM
FROM storeProductHomepageDB
WHERE de_id = 11245 AND (CASE WHEN (parentNUM = 0) THEN lan_id = 0 ELSE (lanParent_id = 0) END)
ORDER BY rootTXT

-----------------------------------
hello there !
Do try out the following query..... might work for you ! :rolleyes:

SELECT detail_id, de_id, subjectTXT, urlTXT, pictureTXT, priceSaleNUM, decode( parentNUM, 0, lan_id, 0, lanParent_id, 0 )
FROM storeProductHomepageDB
WHERE de_id = 11245
ORDER BY rootTXT