How to deal with all foreign keys?

Hi all, Does anyone know the way to update, delete or edit the query after the left join statement? How could I find out what data belongs to what table? What is the primary key of the row iin the what table n the result set? I don't have any ideas this thing could work after complex left outer join? Please help, thanks a lot! Select ProjectName, Company.Name,ProjCompanyType.Type, ProjCompany.ContractCost, Phone.Area_Code, Phone.Phone_Number as 'Phone', PhoneType.Type from Project LEFT JOIN ProjCompany on Project_ID=FKProject_ID left join Company on ProjCompany.FKCompany_ID=Company_ID left join ProjCompanyType on FKProjCompanyType_ID= ProjCompanyType_ID left join Phone on Company_ID=Phone.FKCompany_ID left join PhoneType on Phone.FKPhoneType_ID=PhoneType_ID Calvin