This content has been marked as final. Show 4 replies
Yes, and if you want you can even write reports just using SQL and calculated fields.
Select myDat1*300, myDat1-300 from myTable;
Update myTable a set myDat = (select myDat*300 from myTable b where b.mykey = a.mykey); //requires unique key.
and much more...
plz tell me where i can find these... URL
Pretty much any intermediate to advanced SQL book.
The basic insert from a select or subquery type of stuff should be coverd in any decent SQL book. I use Oracle, so I got a lot of specifics for Oracle's SQL dialect from the Oracle publications and docs. MS-SQL server has similar stuff as does the rest of the production ready SQL DB's.