Forum Discussion

Darius_BD's avatar
Darius_BD
Copper Contributor
May 31, 2022

sql query

Hello, maybe someone could help. I got 2 different ProdCode 2004 and 3069. I need for BazineKaina get value from I33_KODAS_IS =02  For ProdCode 2004 I need get all BazineKaina 2.5500 For ProdCode ...
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jun 06, 2022

Hi Darius_BD -- I'm not sure that I fully understand either, but is something like the query below achieve your desired result?  Take care.


SELECT
ProdCode,
I33_KODAS_IS,
CASE
WHEN I33_KODAS_IS IN ('02') THEN I33_KAINA
WHEN I33_KODAS_IS NOT IN ('02') THEN (SELECT I33_KAINA FROM I33_PKAI WHERE I33_KODAS_IS='02' AND A.ProdCode=ProdCode)
END AS BazineKaina
FROM
    I33_PKAI A
ORDER BY ProdCode,I33_KODAS_IS

 

 

  • chitoova's avatar
    chitoova
    Copper Contributor
    Jun 06, 2022
    tanx https://ariavash.ir/fa very cool

Resources