Dear Cetin,

Thank you very much for the advice. I have included a snippet of code, so that you can actually see what I have done. This code DOES work, of which I am very happy with.

SELECT product.productname, country.countryname, company.compname, ;
city.cityname, Capacity.year, Capacity.npcapacity, ;
Capacity.tempplant ;
FROM dcidatabase!capacity ;
INNER JOIN dcidatabase!product;
ON capacity.productcode = product.productcode ;
INNER JOIN dcidatabase!country ;
ON Country.countrycode = val(left(capacity.tempplant,2)) ;
INNER JOIN dcidatabase!company ;
ON company.compcode = val(substr(capacity.tempplant,3,3)) ;
INNER JOIN dcidatabase!city ;
ON city.citycode=val(right(capacity.tempplant,3)) ;
WHERE country.countrycode=80 AND;
product.productcode=3

However, there is a slight problem - I have two more tables that must be included. These tables (region & state) need to be joined with country. Is this possible? Thank you again for your help.

Jeff