## Query Using Multiple table

 Author Message Neel 7777 Valued Member Group: General Forum Members Points: 60 Visits: 84 I have two table ACINF and ACPMNTAACINFCOMCODE ACTCODE ACTDESC 3305 130000000000 CURRENT ASSETS3305 130100000000 Loans3305 130100010000 3305 130100020000 3305 130100090000 Loan to Others3305 130100090001 Loan to Others3305 130200000000 Loan to Employee (RHEL)3305 130200010000 Loan to Emplyee (RHEL)3305 130200010001 Loan to Emplyee (RHEL)3305 130200010003 Advance to Staffs3305 130200010004 Advance to Parties3305 130200010005 3305 130200010006 3305 130200010007 Advances to Land Owner ( Refundable )query 1 : SELECT COMCOD, ACTCODE, ACTDESCFROM ACINFWHERE (COMCOD = 3305) AND (ACTDESC = '')Returns COMCOD ACTCODE ACTDESC3305 130100010000 3305 130100020000 3305 130200020002 3305 130200020004 3305 130200020005 3305 130200020006 3305 130200020007 3305 130200020008 3305 130200020009 3305 130200020012 3305 130200020013 3305 130200020014 3305 130200020015 3305 130200020018 3305 130200020019 3305 130200020022 3305 130200020026 3305 130200020027 3305 130200020028 3305 130200020038 3305 130200020041 3305 130200020047 3305 130200020048 3305 130200020056 3305 130200020060 Table ACPMNTA COMCOD VOUNUM ACTCODE2305 PV201205000001 1302000100012305 PV201205000002 1302000100012305 PV201205000003 1302000100012305 PV201205000004 1302000100012305 PV201205000005 1302000100012305 PV201205000006 130200010001now i need to run a query to find which of the ACTCODE from ACINF (query 1 showed in the middle) is present in the ACPMNTA.COMCOD = nchar(4)ACTCODE= nchar(12)ACTDESC=nvarchar(100) matak Old Hand Group: General Forum Members Points: 348 Visits: 3739 Take a look at inner joins.Based on what you have written this should get you the information you require. Ed Wagner SSChampion Group: General Forum Members Points: 11459 Visits: 9792 Is this what you're looking for?`SELECT a.COMCODE, a.ACTCODE, a.ACTDESC FROM ACINF a INNER JOIN ACPMNTA b ON b.ACTCODE = a.ACTCODE WHERE a.COMCOD = 3305 AND a.ACTDESC = '';`I'm joining on ACTCODE because I read that you wanted to find the rows in ACINF where ACTCODE is present in ACPMNTA. I included the WHERE clause from your middle query, but you don't have to if it isn't needed. Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions Neel 7777 Valued Member Group: General Forum Members Points: 60 Visits: 84 Thank you very much it id working. Ed Wagner SSChampion Group: General Forum Members Points: 11459 Visits: 9792 No problem. I'm glad it worked for you. Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions