Have two columns:
Pno Dno Quan
311 45 1000
311 40 2000
641 45 3000
551 40 4000
I want to have only the combination of row 1,3 and 5 (sum of Quan is 8000) extracted in a Query, but I have Challenges on how to do this directly in the Query without making a CONCAT Field in the ADSO.
Any idea how I should do this?