InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 17:34:13 GMT20http://www.sqlservercentral.com/Forums/Topic1423866-1292-1.aspxNo problem. I'm glad it worked for you.Wed, 27 Feb 2013 08:26:04 GMTEd Wagnerhttp://www.sqlservercentral.com/Forums/Topic1423866-1292-1.aspxThank you very much it id working.Wed, 27 Feb 2013 01:09:09 GMTRauf Miahhttp://www.sqlservercentral.com/Forums/Topic1423866-1292-1.aspxIs this what you're looking for?[code="sql"]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 = '';[/code]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.Tue, 26 Feb 2013 04:34:16 GMTEd Wagnerhttp://www.sqlservercentral.com/Forums/Topic1423866-1292-1.aspxTake a look at inner joins.Based on what you have written this should get you the information you require.Mon, 25 Feb 2013 22:02:43 GMTmatakhttp://www.sqlservercentral.com/Forums/Topic1423866-1292-1.aspxI 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)Mon, 25 Feb 2013 20:34:34 GMTRauf Miah