Koon Yue Lam,

If you running your MySQL on Windows, you may try to use one of the
reporting tools, like Crystal Report, to create your reports.
Generally these tools allow to hide repetitive data in its reports 

Mikhail Berman

-----Original Message-----
From: Koon Yue Lam [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 24, 2005 1:34 PM
To: mysql@lists.mysql.com
Subject: DB design question

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to