<div>
Thank you sire, your help saved me big time :)<br />
Thank you
</div>


Thank you sire, your help saved me big time :)
Thank you

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
There are two tables having several columns. Now there are three column - account,product,month in both of the tables tblA and tblB. <br />
<br />
I want to find out all the rows for the combination of account,product and month which is in tblA BUT not in tblB<br />
<br />
Any ideas?
</div>
</div>


Hello All,

There are two tables having several columns. Now there are three column - account,product,month in both of the tables tblA and tblB. 

I want to find out all the rows for the combination of account,product and month which is in tblA BUT not in tblB

Any ideas?

TSQL Not In Type

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.