|
Archives of the TeradataForumMessage Posted: Thu, 27 Apr 2006 @ 10:14:02 GMT
<-- Anonymously Posted: Thursday, April 27, 2006 06:10 --> I need to write an sql, which I will illustrate using the following example: (I grouped on col1 values for illustration only): TabA: col1 col2 col3 123 222 1 123 333 2 123 444 1 234 555 1 234 666 1 234 777 1 345 888 2 345 999 2 345 111 2 TabB: col1 col1 col3 col4 Grp1 123 222 1 8 123 333 2 8 123 444 1 8 Grp2 234 555 1 1 234 666 1 1 234 777 1 1 Grp3 345 888 2 2 345 999 2 2 345 111 2 2 I want to populate TabB.col4 so that If all col1's col2 have a col3 value of 1, then 1 (Grp 2 above) If all col1's col2 have a col3 value of 2, then 2 (Grp3 above_ If a col1 has a mix of col2 with a mix of col3 values the set TabB.col4 to 8 (Grp 1 above) Many thanks for any help that you may be able to give.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||