insert into Responses(CaseID,qID,rValue,uID,DateCreated,rOK,isDeleted,
rInstance,ProjectId)
select CaseID,`RE_X_VendorClient`,`4074`,uID,DateCreated,rOK,isDeleted,
rInstance,ProjectId from Responses where qId=`RE_X_Description` and instr(rValue,`Benson`)>0;

select * from Responses where rValue=`4074`;

/*SELECT * FROM `Responses` WHERE qId=`VC_Name`*/

drop table tmpA;
create table tmpA as 
select rUnique,CaseID,qId,rValue,uId,DateCreated,rOK,isDeleted,rInstance,ProjectId from Responses where qId=`RE_X_Description` and isDeleted=0 ;

drop table tmpB;
create table tmpB as 
select rUnique,CaseID,qId,rValue,uId,DateCreated,rOK,isDeleted,rInstance,ProjectId from Responses where qId=`RE_X_VendorClient` and isDeleted=0 ;

drop table tmpC;
create table tmpC as
select tmpA.*,tmpB.qId as tqId,tmpB.rValue as tValue from tmpA left join tmpB on tmpB.CaseId=tmpA.CaseId and tmpB.rInstance=tmpA.rInstance;

select * from tmpC where tqId is null;
