Moritz Eyssen mrzzzrm

## index_query_2.sql
SELECT
  InnerResult.a
FROM
  (SELECT
      T1.a, c
   FROM
      T1 JOIN T2 ON InnerResult.a = InnerResult.c
  ) AS InnerResult;

## index_query_1.sql
SELECT
  InnerResult.T1.a
FROM
  (SELECT
    T1.a, c
   FROM
    T1, T2) AS InnerResult
WHERE
  InnerResult.T1.a = InnerResult.c;

## index_query_0.sql
SELECT
  a, c
FROM
  T1, T2;

## example_tables.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                mrzzzrm
                / example_tables.md
            
            
              Last active
              August 31, 2017 19:27
            
          
    T1


a INT
b INT


0
1


2
3


T2

| a INT | b INT | c INT |
	SELECT
	InnerResult.a
	FROM
	(SELECT
	T1.a, c
	FROM
	T1 JOIN T2 ON InnerResult.a = InnerResult.c
	) AS InnerResult;
	SELECT
	InnerResult.T1.a
	FROM
	(SELECT
	T1.a, c
	FROM
	T1, T2) AS InnerResult
	WHERE
	InnerResult.T1.a = InnerResult.c;