00000001 Sally Silly 7609416682 00000000 Jack Johnson 7609416682 00000000 Jack Johnson 8888888888 00000000 Jack Johnson 5555555555 00000001 Sally Silly 4545454545Cetin's code did the job:
select Contacts.*, Phones.Phone ; from Contacts ; left join links on Contacts.RecordId = Links.ParentID ; and Links.Key == 'phone' ; left join Phones on Links.DataID = Phones.RecordID; INTO CURSOR Results2Thanks Sergey
SELECT Contacts.*, Phones.Phone ; > FROM Contacts ; > JOIN Links ON Links.ParentId = Contacts.RecordId ; > JOIN Phones ON Phones.RecordId = Links.DataId >>
>>Contacts >> | >> -< Links >> | >> -< Phones >> >> >> >>The structures: >> >>Contacts >>RecordId FName LName >>----------------------------------------------------- >>00000001 Joe Smith >> >>Links >>RecordId ParentId DataId Key >>----------------------------------------------------- >>AAAAAAAA 00000001 ZZZZZZZZ "phone" >>AAAAAAAA 00000001 QQQQQQQQ "phone" >>AAAAAAAA 00000001 FFFFFFFF "phone" >> >> >>Phones >>RecordId Caption Phone Last >>----------------------------------------------------- >>ZZZZZZZZ Home 8005551212 .T. >>QQQQQQQQ Business 8001212555 .T. >>FFFFFFFF Cell 8885544877 .T. >>