Pergunta de entrevista da empresa American Power and Gas

Write Queries using Join

Resposta da entrevista

Sigiloso

26 de jun. de 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