<div dir="ltr">Hi Everybody..<br /><br />Let's present my problem:<br /><br />I have a table named <b>t1</b> and i will
insertdifferents values like this :<br /><br />insert into t1 (num,father,child,age) values ('1','joe','bruce','14',);
<br/> insert into t1 (num,father,child,age) values ('1','joe','lei','10',); <br />insert into t1 (num,father,child,age)
values('1','joe','mike','5',); <br /><br />when i use select * from t1 i obtain:<br /><br /><u>num father child
age</u><br/>1 joe bruce 14<br />1 joe lei 10<br />1 joe mike 5<br /><br
/><br/>i want to have <br /><br /><u>num father child age</u><br />1 joe bruce 14<br />
lei 10<br /> mike 5<br /><br />what can i do as select request to obtain this
capture?<br/><br />Thanks :)<br /></div>