Plz giv me solution of this query?

strsql = "insert into target_master (STRTARGET,IUDTARGET,OPTARGET,CCTARGET,PHC_ID,YEAR1,status) select (STRTARGET,IUDTARGET,OPTARGET,CCTARGET,PHC_ID FROM target_master where status='Y' and year1<>" & Val(max1) & "), " & Val(max1) & ",'Y'" in this query i want that max1 and 'y' value should be inserted... show more strsql = "insert into target_master (STRTARGET,IUDTARGET,OPTARGET,CCTARGET,P... select (STRTARGET,IUDTARGET,OPTARGET,CCTARGET,P... FROM target_master where status='Y' and year1<>" & Val(max1) & "), " & Val(max1) & ",'Y'"
in this query i want that max1 and 'y' value should be inserted separtly not from select command how it is possiable
1 answer 1