{ First Query }

SELECT D1.PersonId AS GroupId, D4.LocationDesc, D5.Number, D.PBNoteID
FROM "PBNOTE.DB" D, "USER.DB" D1, "PERSON.DB" D2, "LOCATION.DB" D3, 
"LOCADESC.DB" D4, "TELEPHON.DB" D5
WHERE
(D1.UserId = D.UserId)
 AND (D.PersonId =1)
 AND (D1.PersonId = 1)
 AND (D2.PersonId = D1.PersonId)
 AND (D3.LocationId = D1.LocationId)
 AND (D4.LocationDescId = D3.LocationDescId)
 AND (D5.TelephoneId = D3.TelephoneId)
Order By D4.LocationDesc

{ Second Query }

SELECT Distinct D.PBNoteID, D3.TelephoneId AS GroupId, D2.PersonDesc, 
D4.LocationDesc
FROM "PBNOTE.DB" D, "USER.DB" D1, "PERSON.DB" D2, "LOCATION.DB" D3, 
"LOCADESC.DB" D4, "TELEPHON.DB" D5
WHERE
(D1.UserId = D.UserId)
 AND (D.PersonId = 1)
 AND (D3.TelephoneId = 1)
 AND (D2.PersonId = D1.PersonId)
 AND (D3.LocationId = D1.LocationId)
 AND (D4.LocationDescId = D3.LocationDescId)
 AND (D5.TelephoneId = D3.TelephoneId)
ORDER BY D2.PersonDesc