Sql query question

[maxiachun]

i have a table "Activity" contains two column "personid1" "personid2". i have to select those two column with the personname from person table. how should i write the query?

I am Entry level person

[Krish KP]

can you please provide structure of both tables with sampledata

Regards KP

[Urs Enzler]

something like that: select a.personid1, a.personid2, p1.name, p2.name from Activity a join person p1 on a.personid1 = p1.id join person p2 on a.personid2 = p2.id (didn't test it though) Furthermore, I suggest reading a book about SQL ;)

-^-^-^-^-^- no risk no funk ................... please vote ------>

[John ph]

Activity Table: tblActivity PersonId1 PersonId2 Person Table : tblPerson PersonId PersonName Sql Stmt : SELECT A.PersonId1, (Select PersonName from tblPerson P where P.PersonId = A.PersonId1)AS Person_Name1, A.PersonId2, (Select PersonName from tblPerson P where P.PersonId = A.PersonId2)AS Person_Name2 FROM tblActivity A Regards John