foreach $info_element(@array) { $sql= "SELECT C58XX.CCLMyy, C58XX.CLINyy FROM C58XX WHERE C58XX.CCLMyy=$info_element AND C58XX.CLINyy=$X_LINE "; .... }