i need to iterate thorugh each record in 'companycode' field of 'Company' table and injecting sql query for each record in 'companycode' in 'Customer' table
Let say i hav 3 different company code in one table. For each 3 different copanies i need to count how many members for each company are there in another table
For that i need to iterate through each record in companycode field of company table and put that in an array. How can i get that field in as array......?
How can i iterate through each record and inject sql query into another table
Please help me this is urgent