SQLServerCentral » Latest topics
Two column join between tables, one column with equal to and other columns with not equal to
Two tables each with 6.4 million records in SQL Server 2012. Let's say A and B. I have to join two tables based on two columns. Lets say A.C1 = B.C1 and also A.C2 <> B.C2. Both C1 and C2 are nvarchar columns. Table B does not have cluster index.
No comments:
Post a Comment