Hi, here is the case: one student may have more than one address, and one student may have more than one phone number
so the db would be: student ---------------- student_id name age address --------------- address_id student_id street_name phone_num ------------------ student_id num extension the key of 3 tables are student_id the problems is, when I want to query both student, address and phone num, the sql will be select * from student s, address a, phone_num n where s.student_id = a.sudent_id and s.student_id = n.student_id it won't provide a nice result as data of student are repeated in every row, address and phone_num's data are repeated in certain rows The output is not suitable for reporting and may I ask what is the better way of design to handle the above case ? any help would be apreciated Regards
