Hi!
Ive got a table with these colums;
id, vanl_nr, vtax_kod
If I do a simple select-phrase like this;
I'll get a couple of rows like this
Now the problem. Each vanl_nr can have several vtax_kod, so if I view the first one it might look like this;
So I would like to view all the vtax_kod on those vanl_nr that also has 'vh6' as vtax_kod. Hope atleast someone can understand what Im after
The result should look like this;
I'd also like to alter all the cd1's in the above to cd6, but not ALL the cd1.
Using sql 2000, and sql query analyser.
Can anyone help me out on this??
Thanks in advance!
/Hylsan
Ive got a table with these colums;
id, vanl_nr, vtax_kod
If I do a simple select-phrase like this;
Code:
SELECT vanl_nr, vtax_kod
FROM list
where vtax_kod='vh6'
Code:
vanl_nr vtax_kod
2423421 vh6
2333244 vh6
3232333 vh6
1232344 vh6
Code:
vanl_nr vtax_kod
2423421 vh6
2423421 cd1
2423421 cd2
The result should look like this;
Code:
vanl_nr vtax_kod
2423421 vh6
2423421 cd1
2333244 vh6
2333244 cd1
2333244 cd4
3232333 vh6
3232333 cd1
1232344 vh6
1232344 cd3
1232344 cd4
Using sql 2000, and sql query analyser.
Can anyone help me out on this??
Thanks in advance!
/Hylsan