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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using same table to Add data
I need to add proj1 to proj2 of dates 01/01 and 01/02, keeping in mind that this is in one table. -
Using same table to Add data
I have one table: cno date cname proj1 proj2 proj3 --- ----- ----- ----- ----- ---- 101 01/01 john 50 60 70 101 02/01 tom 40 50 90 103 03/01 mike 30 20 10 My two keys are CNO and DATE. I don't know how to write a query that would perform an...
