>Thanks for your answer.
>Now, I need that the query shows me all records of table1 , have or not linked records in table2 or table3.
>For example :
>
>
>table1.id table1.nombre table2.desc table3.id
>---------------------------------------------------------
>1 Pedro casa 1001
>1 Pedro auto 1001
>2 Juan casa 1003
>2 Juan yate 1003
>3 Alberto auto 1005
>3 Alberto casa 1005
>4 Luis casa
>5 Hugo
>6 Miguel yate 1009
>7 Andres
>8 Carlos casa 1017
Change your joýn type. ie:
...from t1 left join t2 on t1.id = t2.t1id ;
left join t3 on t1.id = t3.t1id...
Cetin