employer cover photo
employer logo
employer logo

American Power and Gas

Est-ce votre entreprise ?

Question d’entretien chez American Power and Gas

Write Queries using Join

Réponse à la question d'entretien

Utilisateur anonyme

26 juin 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