<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#ffffff"
text="#000000">
On 09/08/2011 03:15 PM, Joy Smith wrote:
<blockquote
cite="mid:CAJqhhiNtZKYxQjhXBAkGcXqopDghbUMB87crhoKDQ5HxgFrQaA(at)mail(dot)gmail(dot)com"
type="cite">Hello Chris, yes that does seem to be a lot cleaner -
though it does one thing that is not right -
<div>ie)</div>
<div>add to the previous data</div>
<div> insert into modvalues
(parties,baloons,color,dayofpurchase,amountpur) values<br>
> ('1','big','red','1/2/2011',4);<br>
<br>
</div>
<div><br>
</div>
<div>then the output looks like:</div>
<div><br>
</div>
<div>baloons color jan first jan second jan
third</div>
<div>big red 7</div>
<div>big green 14</div>
<div>big blue 3</div>
<div>big red 4</div>
<div><br>
</div>
<div>instead of looking like this(having big red only show up once
with the new value under jan second):</div>
<div><br>
</div>
<div>
<div>baloons color jan first jan second jan
third</div>
<div>big red 7 4</div>
<div>big green 14</div>
<div>big blue 3</div>
<div><br>
</div>
</div>
<div><br>
</div>
<div>thank you for your help and ideas</div>
</blockquote>
You'll want to group by baloons,color and probably take a sum of
each of the case statements.<br>
<br>
Sim<br>
</body>
</html>