Hi,
It will be more understandable if you post your query with sample data. Its ok, from your query I understand that you want to display all records of "DEWI" where Source equal to 'Production' and 'TypeofTech' in "PWI" equal to '.NET'.
Try this, hope it may help you....
SELECT DEWI.* FROM PWI
INNER JOIN DWI ON DWI.PWIID = PWI.ID
INNER JOIN DEWI ON DEWI.DWIID = DWI.ID
WHERE
PWI.TYPEOFTECH = '.NET'
AND DEWI.SOURCE = 'PRODUCTION'
Regards,
Ashok S