<div>
Select * 
From tblA as A 
Join tblB as B 
On A.col1 = B.col1 and 
A.col2 = B.col2 and 
A.col3 = B.col3
</div>

<div>
Second one: 
 
Select * 
From tblA as A 
Join tblB as B 
On A.col1 = B.col1 and 
A.col2 = B.col2 and 
A.col3 &lt;&gt;&nbsp;B.col3
</div>

<div>
Maybe a UNION can give you a better view of what you want: 

<pre><code class="code-10 nolinks" id="code-20-40450230-1">SELECT TblA.Col1, TblA.Col2, TblA.Col3, 'COL3 EQUAL'
FROM TblA, TblB 
WHERE TblA.Col1= TblB.Col1 
 and TblA.Col2 = TblB.Col2 
 and TblA.Col3 = TblB.Col3
UNION ALL
SELECT TblA.Col1, TblA.Col2, TblA.Col3, 'COL3 NOT EQUAL'
FROM TblA, TblB 
WHERE TblA.Col1= TblB.Col1 
 and TblA.Col2 = TblB.Col2 
 and TblA.Col3 &lt;&gt; TblB.Col3
</code></pre>
</div>

<div>
Depending on the SQL dialect, you may be able to do something like this: &nbsp; 
 
Select tblA.*, tblB.* , 3 as NumMatchedItems 
from tblA inner join tblB ON &nbsp;tblA.col1=tblB.col1 AND tblA.col2=tblB.col2 AND tblA.col3=tblB.col3 
UNION ALL 
Select tblA.*, tblB.* , 2 as NumMatchedItems 
from tblA inner join tblB ON tblA.col1=tblB.col1 AND tblA.col2=tblB.col2 
WHERE NOT EXISTS &nbsp; 
&nbsp; ( select * 
&nbsp; &nbsp;from tblA A2 inner join tblB B2 ON &nbsp;A2.col1=B2.col1 AND A2.col2=B2.col2 AND A2.col3=B2.col3 &nbsp; 
&nbsp; WHERE A2.col1=tblA.col1 and a2.col2=tblA.col2 
&nbsp;) 
 
The second query ( everything after the Union All) will only find results if the first query has no matching item with the same vales for col1 and col2. &nbsp;The &quot;nummatcheditems&quot; column is included as a check to see what is coming back when you are testing.
</div>

<div>
Vitor's suggestion will always return the exact and inexact matches, which seems not to be intended. 
A partial outer join might be the best way. However, it is not clear what exactly should be returned - the fields of TblA only, or COl3 of TblB instead or in addition? 

<pre><code class="code-1 nolinks" id="code-20-40450294-1">select tblA.Col1, tblA.Col2, tblA.Col3, tblB.Col3
from tblA
left join tblB on tblA.Col1 = tblB.Col1 and tblA.Col2 = tblB.Col2 and tblA.Col3 = tblB.Col3
where tblA.Col1 = tblB.Col1 and tblA.Col2 = tblB.Col2
</code></pre>
</div>

<div>
I tested my suggested code above the above using this data: &nbsp; 
 
TBLA 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; 
b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;e &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 
 
TBLB 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
f &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;g &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;h &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4 &nbsp; &nbsp; 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 
 
 
and it finds an exact match between the two ABC &nbsp;and ABE rows ; and a partial match between the two ACx rows; and it does not return a partial match between ABC and ABD because there is an exact match with ABC. 
 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2 
 
 
Is this the kind of behaviour you want ?
</div>

<div>
Thanks. &nbsp; 
 
These examples are close to what I need but not quite there yet. 
 
I need if col3 &lt;&gt;&nbsp;col3 then return the match on col1 = col1 and col2=col2
</div>

<div>
So sorry...bad day. &nbsp;This SQL is 100% what I need..again very sorry..getting confused clearly need help! 
 
DROP TABLE [dbo].[tblA] 
GO 
DROP TABLE [dbo].[tblB] 
GO 
CREATE TABLE [dbo].[tblA] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ([Col1] [VARCHAR](50) NULL 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,[Col2] [VARCHAR](50) NULL 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,[Col3] [VARCHAR](50) NULL 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ) 
ON &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;[PRIMARY] 
 
GO 
 
CREATE TABLE [dbo].[tblB] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ([Col1] [VARCHAR](50) NULL 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,[Col2] [VARCHAR](50) NULL 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,[Col3] [VARCHAR](50) NULL 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,[Output] [INT] NULL 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ) 
ON &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;[PRIMARY] 
 
GO 
INSERT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[dbo].[tblA] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;([Col1], [Col2], [Col3]) 
VALUES &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(N'A', N'B', N'C') 
GO 
INSERT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[dbo].[tblB] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;([Col1], [Col2], [Col3], [Output]) 
VALUES &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(N'A', N'B', N'C', 1) 
GO 
INSERT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[dbo].[tblB] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;([Col1], [Col2], [Col3], [Output]) 
VALUES &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(N'A', N'B', NULL, 2) 
GO 
 
SELECT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* 
FROM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbo.tblA TA 
SELECT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* 
FROM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbo.tblB TB 
 
GO 
 
--I would like to join the tables but return only Output 1 here 
 
 
SELECT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TA.Col1 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,TA.Col2 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,TA.Col3 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,TB.Output 
FROM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbo.tblA TA 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER JOIN dbo.tblB TB 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON TA.Col1 = TB.Col1 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;AND TA.Col2 = TB.Col2 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;AND TA.Col3 = TB.Col3 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;GO 
 
--And output 2 here - 
 
DELETE FROM dbo.tblB 
WHERE Output = 1 
 
SELECT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* 
FROM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbo.tblA TA 
SELECT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* 
FROM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbo.tblB TB 
 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;GO 
 
SELECT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TA.Col1 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,TA.Col2 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,TA.Col3 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,TB.Output 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ,'This should return Output 2 now. &nbsp;I need sql to handle both situations in one pass' 
FROM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbo.tblA TA 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER JOIN dbo.tblB TB 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON TA.Col1 = TB.Col1 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;AND TA.Col2 = TB.Col2 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;AND ISNULL(TA.Col3,'') = ISNULL(TB.Col3,'') 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;GO
</div>

<div>
I'm not sure what you're trying to do with the final ISNULL comparison, but it doesn't look like it will do what you described in the initial posting. As I understand it, as long as Col1 and Col2 match, you want to see some matching results. &nbsp;But the ISNULL expression &nbsp;&quot; AND ISNULL(TA.Col3,'') = ISNULL(TB.Col3,'') &nbsp;&quot; &nbsp;will only return TRUE if Col3 is equal in both tables, or if it is NULL in both tables. 
 
Did you try the code I posted earlier ? Maybe you could set up to work with your own test data and see what it gives. &nbsp;You might want to change the part of the code which specifies the columns included in the output. &nbsp; 
 
If that doesn't give you the output that you need, &nbsp;come back and describe the way in which the data that it returns is wrong, and that might give us something else to go on.
</div>

<div>
I need sql that 
 
If it can get a join on 3 columns then return that row 
 
elseif it cant get a join on 3 columns but can on 2 column return that row instead 
 
if it can't join on 2 or 3 return nothing 
 
It may be the case that it can join on 2 and 3 colums both returning different rows. &nbsp;In this case the 3 column match wins and that 3 column match should be returned. 
 
Thanks
</div>

<div>
That sounds like what the code that I posted does. &nbsp; In my sample data: 
 
Where TBLA and TBLB both contain (A,B,C) , the matching rows are returned 
We don't match TBLA(A,B,C) with TBLB (A,B,D) because there is an exact match for A,B,C 
 
Where TBLA and TBLB both contain (A,B,E) , the matching rows are returned 
We don't match TBLA(A,B,E) with TBLB (A,B,D) because there is an exact match for A,B,E 
 
Where TBLA contains (A,C,D) and TBLB contains (A,C,E) the partially matching rows are returned because there are no exact matching rows.
</div>

<div>
To have a better example, let's asume we have the following: 

<pre><code class="code-10 nolinks" id="code-20-40452178-1">DROP TABLE [dbo].[tblA]
GO
DROP TABLE [dbo].[tblB]
GO
CREATE TABLE [dbo].[tblA]
 ([Col1] [VARCHAR](50) NULL
 ,[Col2] [VARCHAR](50) NULL
 ,[Col3] [VARCHAR](50) NULL
 )
GO

CREATE TABLE [dbo].[tblB]
 ([Col1] [VARCHAR](50) NULL
 ,[Col2] [VARCHAR](50) NULL
 ,[Col3] [VARCHAR](50) NULL
 ,[Output] [INT] NULL
 )
GO

INSERT [dbo].[tblA] ([Col1], [Col2], [Col3]) VALUES ('A', 'B', 'C')
INSERT [dbo].[tblB] ([Col1], [Col2], [Col3], [Output]) VALUES ('A', 'B', 'C', 1)
INSERT [dbo].[tblB] ([Col1], [Col2], [Col3], [Output]) VALUES ('A', 'B', NULL, 2)

INSERT [dbo].[tblA] ([Col1], [Col2], [Col3]) VALUES ('X', 'Y', 'Z')
INSERT [dbo].[tblB] ([Col1], [Col2], [Col3], [Output]) VALUES ('X', 'Y', NULL, 2)
GO
</code></pre>
The expectation would be 
&nbsp; A B C 1 
&nbsp; X Y Z 2 
then.
</div>

<div>
&gt;&gt; Scott's would need severe rework to allow for having Output in the result. &lt;&lt; 
 
Huh? &nbsp;I don't follow that. &nbsp;If other column(s) are needed from TblB, just use an OUTER APPLY instead of a subquery. &nbsp;I don't consider that a &quot;major rewrite&quot;, but that is subjective of course :). 
 
There was no mention of SELECTing additional columns from TblB in the original q. &nbsp;I try to write queries to be as efficient as possible, so if a capability is not needed I don't add it to the code unnecessarily. 
 
 
SELECT a.col1, a.col2, a.col3, 
&nbsp; &nbsp; b.col3, --if NULL, no match was found on col3 
&nbsp; &nbsp; b.output, --if NULL, no match was found on col3 
&nbsp; &nbsp; b.output2 --if NULL, no match was found on col3 
FROM TblA a 
OUTER APPLY ( 
&nbsp; &nbsp; SELECT b2.col3, b2.output, b2.output2 --,...other col(s)... 
&nbsp; &nbsp; FROM TblB b2 
&nbsp; &nbsp; WHERE 
&nbsp; &nbsp; &nbsp; &nbsp; b2.col1 = a.col1 AND 
&nbsp; &nbsp; &nbsp; &nbsp; b2.col2 = a.col2 AND 
&nbsp; &nbsp; &nbsp; &nbsp; b2.col3 = a.col3 &nbsp; &nbsp; 
) AS b 
WHERE 
&nbsp; &nbsp; EXISTS( 
&nbsp; &nbsp; &nbsp; &nbsp; SELECT 1 
&nbsp; &nbsp; &nbsp; &nbsp; FROM TblB b 
&nbsp; &nbsp; &nbsp; &nbsp; WHERE 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b.col1 = a.col1 AND 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b.col2 = a.col2 
&nbsp; &nbsp; )
</div>

<div>
I selected my own solution because it works
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
 
I have 2 tables. 
 
 
TblA &nbsp;Col1, Col2, Col3 
 
TblB Col1, Col2, Col3 
 
I need to join them BUT.... 
 
I need to return a row if ALL 3 Cols equal. 
 
Col1= Col1 
and Col2 = Col2 
and Col3 = Col3 
 
but 
 
If ALL 3 Cols do NOT equal but 
 
Col1 = Col1 
and Col2 = Col2 
and Col3 &lt;&gt;&nbsp;Col3 
 
then return that row instead 
 
So its sort of a double pass. &nbsp;First pass is &quot;do all 3 cols equal&quot; if not &quot;do Cols 1 &amp;&nbsp;2 equal&quot;, if not return nothing. 
 
I am stumped, please help 
 
Thanks 
 
nutnut
</div>
</div>

Hi,

I have 2 tables.


TblA Col1, Col2, Col3

TblB Col1, Col2, Col3

I need to join them BUT....

I need to return a row if ALL 3 Cols equal. 

Col1= Col1 
and Col2 = Col2 
and Col3 = Col3

but

If ALL 3 Cols do NOT equal but 

Col1 = Col1 
and Col2 = Col2 
and Col3 <> Col3

then return that row instead

So its sort of a double pass. First pass is "do all 3 cols equal" if not "do Cols 1 & 2 equal", if not return nothing.

I am stumped, please help

Thanks

nutnut

SQL Join

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

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.