If you have A relationship Diagram between them
use:-
select ...,...,...,... from table1,table2,table3
Without a relationship Diagram use inner join:-
select ....,...,....,.... from table1 inner join table2
on table1.PID=table2.PID
inner join table3
on table2.PID=table3.PID