Skip to main content
. Author manuscript; available in PMC: 2015 Sep 1.
Published in final edited form as: IEEE J Biomed Health Inform. 2014 Sep;18(5):1607–1613. doi: 10.1109/JBHI.2013.2292591

Fig. 1.

Fig. 1

The general framework of a CTE containing N common tables that join N select statements. In each common table, a select statement determines the result set and previous common tables can be referenced in subsequent ones. The last SELECT statement dictates what the final result set will be.