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 Chriss Miller 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: *
- Users: Thumper2004
- Content: Threads
- Order by date
-
Pull from one table to fill a record in another
I want to update table 1 field 1 with a value from table 2 field 1 and keep getting subquery returns more than one record. update table 1 field 1; from table 2 field 1; where table1.key=table2.key UPDATE table1 t1; SET field 1 =; (select t2.field1; from table1 t1; join table2 t2 on...- Thumper2004
- Thread
- Replies: 11
- Forum: Microsoft: FoxPro
-
icase issues - unexpected results
So I am a software technical support rep for my company, and I do data analysis and data cleanup when needed. I am having some issues with a SQL/FOX program. Using FoxPro 9. UPDATE table1; SET datefield1 =; ICASE(; t1.datefield2 < CTOD("04/23/2018") AND t1.datefield2 >...- Thumper2004
- Thread
- Replies: 7
- Forum: Microsoft: FoxPro
