Search results for query: *

That is what happened Olaf originally, which is what brought me out here trying to find help. The consideration that table2 had a 1:n relation was not taken into account. Once that was taken into account and the adjustments made to only return one record out of table2 for each primkey from...

So the issue was finally identified as table2 returning multiple records for the primary key/foreign key correlation from table1 to table2. So we told it to only return the max key for each t1 primary key = t2 foreign key. Thanks for all your help guys on this and the other one as well. I wish I...

OK So i am not a developer, how do you populate the cursor with what already exists in the other tables.

Thanks Olaf. I will give that a try tomorrow. It’s been a frustrating conundrum! Thanks again !!

Olaf, I have the original data. The updates I am doing are on a copy database and I can replace the tables that are modified with the originals and be back to square. Every attempt to fill the t1.field1 with t2.field1 results in every record t1.field1 being changed to the t2.field1 value. I need...

Thanks TamarGranor, but I have to qualify the lower end of the date range because empty is considered less than and we don't want to consider empty. I also have to reference table 2 unless the table is table2.field1 TamarGranor (Programmer)3 May 18 20:24 Based on your other posts, I'm going...

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...

The t1.datefield1 is still being populated with the first records t2.datefield3 for all records in the table.

So here is the order by which items should populate: t2.datefield3 t2.datefield1 t2.datefield2 t3.datefield1 t3.datefield2 If none of the conditions are met leave as is. All of the date columns do not allow Nulls Also remember guys I have no formal training in programming. Its just what I...

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 >...