code for abc table relation

code for abc table relation

a=IPMComodityTable

b=IPMPFComodityLines

c=IPMFinancialCompanies

ac having relation

ab having relation 

we want bc relation then

public display Name Country()
{

IPMComodityTable IPMComodityTable;
IPMPFComodityLines IPMPFComodityLines,IPMPFComodityLinesLoc;
IPMFinancialCompanies IPMFinancialCompanies;
str name;

select IPMPFComodityLinesLoc join IPMComodityTable where IPMComodityTable.ComodityID == this.ComodityID
join IPMFinancialCompanies where IPMFinancialCompanies.CompanyCode == IPMComodityTable.FinOrg;
/* while select IPMPFComodityLines join IPMComodityTable
join IPMFinancialCompanies
where IPMPFComodityLines.ComodityID == IPMComodityTable.ComodityID
&& IPMComodityTable.FinOrg == IPMFinancialCompanies.CompanyCode

//nfo(strFmt(“%1″ , IPMFinancialCompanies.CompanyName));
name = IPMFinancialCompanies.CompanyName;*/
return IPMFinancialCompanies.Country;
}