You can do that using JOINS.
You need to learn SQL JOIN first and then you can easily find the appropriate solution to your problem.
References:
SQL Joins[
^]
You query should look like :
SELECT Clientid,cproduct,dueamt
FROM
ClientName C
LEFT JOIN Collection L ON L.uniqueid=C.clientid
LEFT JOIN WorckData W ON W.paymentid=C.id
WHERE cproduct='Yes' AND paymentstatus='N'
Hope, that helps :)