#> #>This will create another table TmpTable (tax, direction), #>using the values from the table MarketTable: #> #>create table TmpTable as #>select tax, #>(select #> case when b.tax < MarketTable .tax #> then "Up" #> when b.tax>=MarketTable .tax #> then "Down" #> else null #> end #> from MarketTable b #> where b.rowid=MarketTable.rowid-1) from MarketTable #> #>If you need to include other columns, you can list them at #>the top level select. #> #>Wes #>
Ah, I get it. Nice. Thank you! Rick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users