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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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! -
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...
