there are 2 types of students; boys and girls so they all belong to student.
i query separately the list of boys and girls;
so the boys will have allowance of 500
while the girls will have an allowance of 1000
i had the query right in getting the list of all boys name and girls name.. no how am i going to set a value in their allowance.. i mean.. you may think it is insane but i need to store their allowance...
is it like
select name from students where student_type = 'boys' and give value to allowanct = 500??
is that right?