Get referenced table column in a select list item
This simple demo illustrates how to get table and columns involved in a select list item like this:
select sal.income + sal.bonus * emp.age + 5 as real_sal,
emp.name as title
from employee emp, salary sal
where emp.id=sal.eid
What this demo do is tell you that in select list item:
sal.income + sal.bonus * emp.age + 5 as real_sal
columns been referenced are listed below:
salary.income salary.bonus employee.age
General SQL Parser can handle this well no matter how complex the select list item is.
Download demo: Java version
