Domanda di colloquio di American Power and Gas
Write Queries using Join
Risposta di colloquio
Anonimo
26 giu 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