how to search one person all information from many tables???

Answer 1

Select A.*,B.*,C.*,D.*,E.*
from A
inner join B on A.a_id = B. a_id
inner join C on B.b_id = C.b_id
inner join D on B.b_id = D.b_id
inner join E on D.d_id = E.d_id

*You can use your own tables..

Answer 2

SELECT Person.FirstName,
Person.LastName,
PersonPhone.PhoneNumber
FROM Person.Person
INNER JOIN Person.PersonPhone
ON Person.BusinessEntityID =
PersonPhone.BusinessEntityID