正则查寻包含某个字符串_ASP.NET

正则查找包含某个字符串
string viewScript = " left join (select T1 as T2 from Table group by T1 ) as t on t (select 1 from TT) as c";

我想得到的结果是 left join (select T1 as T2 from Table group by T1 ) t on t (select 1 from TT) c

我是样写只能替换掉最后一个as
viewScript = Regex.Replace(viewScript, "join(.*)as ", "join $1", RegexOptions.IgnoreCase);

正则里怎么加个from，但不知道写
viewScript = Regex.Replace(viewScript, "join((from).*)as ", "join $1", RegexOptions.IgnoreCase);

------解决方案--------------------------------------------------------

C# code

string viewScript = " left join (select T1 as T2 from Table group by T1 ) as t on t (select 1 from TT) as c";viewScript = Regex.Replace(viewScript, @"(?i)as ", "");
------解决方案--------------------------------------------------------
C# codestring viewScript = " left join (select T1 as T2 from Table group by T1 ) as t on t (select 1 from TT) as c";                viewScript = Regex.Replace(viewScript,@"(?<=join\s*?\([^)]+?\).*?)\s+as\s+"," ");                // left join (select T1 as T2 from Table group by T1 ) t on t (select 1 from TT) c
------解决方案--------------------------------------------------------
C# code            string source = "left join (select T1 as T2 from Table group by T1 ) as t on t (select 1 from TT) as c";            Regex reg = new Regex(@"(?<=\([^\)]*?\) )as");            source = reg.Replace(source, @"");
------解决方案--------------------------------------------------------
C# code string sql=@"string viewScript = "" left join (select T1 as T2 from Table group by T1 ) as t on t (select 1 from TT) as c"; sql= Regex.Replace(sql, @"(?<=\)\s+)as", "");