Illustrate how to fetch information from join table in from clause.
jointabledetail.cs
join.sql
TLzJoin
TLzJoinItem
http://www.sqlparser.com/dl/samples/jointabledetail.zip