I need a regex to pull out the table names from sql statements in jpl files. These are just text files. A simple example is: sql select last_name, first_name, id from table_a but this can also be like: sql select a.last_name, b.first_name, a.id from table_a a, table_b b where a.id = b.id order by a.id In this case I would need to pull out ...

Hello, I still learn to use regex, but have still some problems, and can't go further without your help. This time I have a SQL like this: insert into DataWarehouse.dbo.Users (Forename, SurName) values ('John', 'Dark')   I would like to capture 'DataWarehouse' and 'Users' that is database name and table ...