Can anyone tell me what's wrong in this query ? UPDATE tableA SET submitted_from_ip=(SELECT vqs.fieldvalue FROM viewA vqs join tableA fqs on vqs.formid=fqs.formid AND vqs.SubmitTime=fqs.submit_time WHERE vqs.fieldname='submitted_from_ip') JOIN tableA fqs on vqs.formid=fqs.formid AND vqs.SubmitTime=fqs.submit_time WHERE vqs.fieldname='submitted_from_ip';
... View more
