employer cover photo
employer logo
employer logo

American Power and Gas

Is this your company?

American Power and Gas Interview Question

Write Queries using Join

Interview Answer

Anonymous

Jun 26, 2019

SELECT A.id, A.firstName, A.LastName , B. address1, B.address2. B.city FROM Person A JOIN Address B on A.id=B.id A.id is primary key on table Person and B.id is foreign key in table Address B