Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mistermci

    problems with insert INTO

    I am trying to take all values/columns from one table and combine it with all values/columns from another table. I tried the this: INSERT INTO table1(*) select * from table2 but it didn't work...can anyone help me out? Thanks!
  2. mistermci

    Subtracting Current row from Previous

    I am trying to create a query that will subtract the current row of a column from the previous row, and if the value is negative, just return the value of the current column in the result column. For example, if I had the table below, here are the results I would like to see: Key value...

Part and Inventory Search

Back
Top