how to search one person all information from many tables??? | Sololearn: Learn to code for FREE!
+ 1

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

27th Mar 2017, 6:29 AM
Tanvir Ahmed Nabil
Tanvir Ahmed Nabil - avatar
2 Answers
+ 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..
27th Mar 2017, 7:06 AM
Akwin Lopez
Akwin Lopez - avatar
0
SELECT Person.FirstName, Person.LastName, PersonPhone.PhoneNumber FROM Person.Person INNER JOIN Person.PersonPhone ON Person.BusinessEntityID = PersonPhone.BusinessEntityID
27th Mar 2017, 7:07 AM
Akwin Lopez
Akwin Lopez - avatar