[ask]sql query

[SinggahDapur]

gan,misalny gua punya query keq gini..



SELECT abc,cde, 'jumlah' = CASE WHEN abc is null then 0 else (qty1-qty2) end



trus misalny gua mau tambahin 1 kolom lagi, misalny namany "total".

total = jumlah + cde



gua coba keq gini tp kolom jumlah invalid katanya

SELECT abc,cde, 'jumlah' = CASE WHEN abc is null then 0 else (qty1-qty2) end, (jumlah+cde) as total





gimana yah carany?

thanks

</div>