SQL WHERE.. IN clause multiple columns

by

You’ll want to use the WHERE EXISTS syntax instead.

SELECT *
FROM table1
WHERE EXISTS (SELECT *
              FROM table2
              WHERE Lead_Key = @Lead_Key
                        AND table1.CM_PLAN_ID = table2.CM_PLAN_ID
                        AND table1.Individual_ID = table2.Individual_ID)

More Related Contents:

  1. How do I use cascade delete with SQL Server?
  2. An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
  3. How to add Active Directory user group as login in SQL Server
  4. Maximum size of a varchar(max) variable
  5. SQL Server pivot vs. multiple join
  6. Real vs. Floating Point vs. Money
  7. how to make your data horizontal
  8. How do I find a stored procedure containing ?
  9. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  10. How to check if a Constraint exists in Sql server?
  11. An attempt to login using SQL authentication failed
  12. What does “ORDER BY (SELECT NULL)” mean?
  13. Parse XML in SQL Server
  14. Calling stored procedure using VBA
  15. How to find SQL Server running port?
  16. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  17. SQLServer IDENTITY Column with text
  18. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  19. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  20. Database design: Calculating the Account Balance
  21. Cannot bulk load. Operating system error code 5 (Access is denied.)
  22. INFORMATION_SCHEMA vs sysobjects
  23. Does query plan optimizer works well with joined/filtered table-valued functions?
  24. SQL Server 2008 can’t login with newly created user
  25. How to set value to variable using ‘execute’ in t-sql?
  26. Nested transactions in Sql Server
  27. Taking the second last row with only one select in SQL Server?
  28. What is the difference between Cartesian product and cross join?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment