مشكلة اثناء البحث بين 3 جداول

المشكلة كانت بالكود ... وهاهو التعديل لتعم الافادة

select contracts.cono as 'Contract No.' ,contracts.codate as 'Contract Date',
contracts.cototval as 'Contract Value' ,contracts.covalutak as 'Paid',
contracts.cototval - contracts.covalutak as 'Remain' ,emanpwr.pname as 'Servant Name',
emanpwr.pid as 'Code NO.',customer.cname as 'Customer Name',
customer.cnid as 'ID'
from contracts inner join emanpwr on
contracts.emanpwr = emanpwr.emanpwr
inner join customer on contracts.cuid = customer.cuid