具有挑战性的正则表达式问题,我有15000分
gypb 2006-06-29 10:54:02 有如下sql
select * from (select * from tablea) a,(select * from table b) b,
tablec c,tabled e
where a.key = b.key and b.key = c.key and c.key = e.key
要求提取出 from 后的表名和 表别名,包括子查询
例如返回结果
select * from tablea ,别名 a
select * from table b , b
tablec c
tabled e