Ändra villkor om inte första finns

Har två tabeller.

CREATE TABLE [Table1] 
(
   [Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
   [Number] [varchar] (50) COLLATE Finnish_Swedish_CI_AS NOT NULL ,
   [TimeStamp] [smalldatetime] NOT NULL CONSTRAINT [DF_Table1_TimeStamp] DEFAULT (getdate()),
   CONSTRAINT [PK_Table1] PRIMARY KEY  CLUSTERED 
   (
      [Id]
   )  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [Table2] 
(
   [Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
   [Table1Id] [int] NOT NULL ,
   [LingoId] [int] NOT NULL ,
   [Header] [nvarchar] (150) COLLATE Finnish_Swedish_CI_AS NOT NULL ,
   [Description] [ntext] COLLATE Finnish_Swedish_CI_AS NOT NULL ,
   CONSTRAINT [PK_Table2] PRIMARY KEY  CLUSTERED 
   (
      [Id]
   )  ON [PRIMARY] ,
   CONSTRAINT [FK_Table2_Table1] FOREIGN KEY 
   (
      [Table1Id]
   ) REFERENCES [Table1] (
      [Id]
   )
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Vad jag skulle vilja är att om LingoId = 2 i nedan fråga inte finns så skall den istället ta ut där LingoId = 1 som alltid finns. Går detta?

SELECT
   dbo.Table1.Id, 
   dbo.Table1.Number, 
   dbo.Table1.[TimeStamp], 
   dbo.Table2.Header, 
   dbo.Table2.Description
FROM         
   dbo.Table1 
      LEFT OUTER JOIN
         dbo.Table2 ON dbo.Table1.Id = dbo.Table2.Table1Id
WHERE
   (dbo.Table2.LingoId = 2) --Sen behövs det då något här.