regex101: Capture MSSQL tables and their potential aliases

Pro

\sany whitespace character

Non-Capturing Group(?:from|join)

1st Alternativefrom

fromthe literal text from (case insensitive)

2nd Alternativejoin

jointhe literal text join (case insensitive)

\s*any whitespace character, repeated any number of times

Group 1(\[?[\S]+)

\[?optionally matches the literal [ (91₁₀ / 133₈ / 5B₁₆)

Character Class[\S]+

+matches at least one character from the set below:

\Sany non-whitespace character

\]?optionally matches the literal ] (93₁₀ / 135₈ / 5D₁₆)

Non-Capturing Group(?:\s?)

\s?optionally matches any whitespace character

Non-Capturing Group(?:(?:as)?\s?)

Non-Capturing Group(?:as)?

?repeats the group contents below at most once:

asthe literal text as (case insensitive)

\s?optionally matches any whitespace character

1st Alternativejoin

jointhe literal text join (case insensitive)

2nd Alternativewhere

wherethe literal text where (case insensitive)

3rd Alternativefrom

fromthe literal text from (case insensitive)

4th Alternativeleft

leftthe literal text left (case insensitive)

5th Alternativeright

rightthe literal text right (case insensitive)

6th Alternativeouter

outerthe literal text outer (case insensitive)

7th Alternativeinner

innerthe literal text inner (case insensitive)

8th Alternativeon

onthe literal text on (case insensitive)

Group 3(\w*)

\w*any word character, repeated any number of times

Global pattern flags

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

g modifier: global. Finds all matches instead of stopping after the first

25 tokens

Regular Expression

\s(?:from|join)\s*(\[?[\S]+)\]?(?:\s?)(?:(?:as)?\s?)(?!(join|where|from|left|right|outer|inner|on))(\w*)

New


SELECT a.ACCTNO, 
case [DCCDRID] when 'N/A' then 'N/A' else dbo.GETDocNames(DCCDRID) end AS [Specific Documents Needed],
a.CUSTRF, 
b.[RLEXT#], 
a.APPLCT, 
a.SADDR1, 
a.SADDR2, 
a.SCITY, 
a.SSTATE, 
a.SZIP, 
a.CFOReqstType
FROM (
SELECT a.ACCTNO, 
a.CUSTRF, 
a.MINNBR, 
a.[GSE_NO] AS [FNMA#], 
a.GSEPN AS [FNMA MBS Pool Number], 
a.GSESN AS [FNMA Master Servicer Number], 
a.APPLCT, 
a.SADDR1, 
a.SADDR2, 
a.SCITY, 
a.SSTATE, 
a.SZIP, 
a.RefreshRunDT AS [Request Date], 
a.TRANDT AS [Paid Date], 
a.OrgLnBal AS [Orig Loan Amt], 
b.CustodianName, 
a.FileDestName, 
a.CSTSEQ, 
a.CSTFileDest, 
a.CSTRelCode, 
a.CFOOrderReasonCode, 
a.CFOReqstType, 
a.DCCDRID
FROM [PRODLIB].[dbo].[DOCUS_SYS_REFRESH_CFO_DAILY] a
INNER JOIN tbl_DC_CLU_CUSTD b 
	ON a.CSTSEQ = b.CSTSEQ
WHERE a.CSTSEQ In (23,34,35,39,53,54)
) a 
INNER JOIN DOCUS_PRODLIB_CLPREFAL b
	ON a.ACCTNO = b.[RLNEW#]
WHERE a.CSTSEQ = 23