SA0051 : The query is missing a join predicate. This may affect or result more than expected rows

 1DECLARE  @StartProductID          AS  [int]
 2       , @CheckDate               AS  [datetime]
 3
 4SET @StartProductID = 111
 5SET @CheckDate = getdate(  );
 6
 7SELECT      *
 8FROM        OrderDetails
 9
10SELECT      *
11FROM        dbo.Orders
12INNER JOIN  dbo.OrderDetails AS od
13ON          1 = 2
14WHERE       od.OrderId = '00012345'
15
16
17SELECT      *
18FROM        [HumanResources].[Employee] AS e
19          , [Person].[Person] AS p
20          , [Person].[EmailAddress] AS ea
21WHERE       p.[BusinessEntityID] = e.[BusinessEntityID]
22
23SELECT      *
24FROM        table1
25          , table2
26WHERE       1 = 2
27
28
29SELECT      *
30FROM        table1
31          , table2
32WHERE       1 = 2 -- IGNORE:SA0051
33
34
35SELECT t1.*, t2.*
36FROM table_1 t1
37CROSS JOIN Table_2 t2;
38
39SELECT t1.*, t2.*
40FROM Table_1 t1, Table_2 t2;