try this..

select t.id,t.from,t.to,t.date,t.fare,s.seat,u.first_name,u.last_name from trip t,seat s,user_information u where t.id=s.id