sql - 在 INNER JOIN 子句中使用 OR

问题描述

我有一个动态查询，我在其中声明了 3 个不同的变量，例如：

       DECLARE @JobNoteQuery NVARCHAR(MAX) = IIF(@JobNote = '%' , '' , ' INNER JOIN (SELECT ParentGuid FROM JobNotes JN WITH (NOLOCK) 
                            WHERE JN.Note LIKE ''%''+@JobNote+ ''%''
                            GROUP BY ParentGuid) JN ON P.ProjectGuid = JN.ParentGuid');

       DECLARE @ContactQuery NVARCHAR(MAX) = IIF(@Contact = '%' , '' , ' LEFT JOIN(SELECT
                        [ProjectKey]
                        FROM [ProjectCustomerContact] AS [pcc]
                            LEFT JOIN [Contact] AS [c] ON [c].[ContactKey] = [pcc].[ContactKey]
                        WHERE [c].[LastName] LIKE ''%''+@LastName+''%'') AS [pcc] ON [pcc].[ProjectKey] = [p].[ProjectKey]')

       DECLARE @CustomerQuery NVARCHAR(MAX) = IIF(@Customer = '%' , '' , 'LEFT JOIN(SELECT
                        [ProjectKey]
                        FROM [ProjectCustomer] AS [pc]
                            LEFT JOIN [Customer] AS [c] ON [c].[CustomerKey] = [pc].[CustomerKey]
                        WHERE([c].[Name] LIKE ''%''+@CustName+''%''
                            OR [c].[DBA] LIKE ''%''+@CustName+''%'')) AS [PC] ON [pc].[ProjectKey] = [p].[ProjectKey]')

因此，在选择查询中，我将该变量用于 Joins 子句，例如：

  ...INNER JOIN [Region] AS [re] ON [a].[RegionKey] = [re].[RegionKey]
                          '+@JobNoteQuery+'
                          '+@ContactQuery+'
                          '+@CustomerQuery+'
                       WHERE...

我的问题是。如果我的树参数返回它们的值，我的意思是@JobNoteQuery，@ContactQuery并且 @CustomerQuery，总是返回内部和左连接，但如果其中一个没有值，则值可以为 null，它只会返回空列表，所以有什么方法可以使用OR子句进入INNER JOINS？像：

 ...INNER JOIN [Region] AS [re] ON [a].[RegionKey] = [re].[RegionKey]
          OR
                              '+@JobNoteQuery+'
          OR
                              '+@ContactQuery+'
          OR
                              '+@CustomerQuery+'
                           WHERE...

那不可能？问候

标签： sqlsql-servertsql

sql - 在 INNER JOIN 子句中使用 OR

问题描述

解决方案

推荐阅读