sminnee / silverstripe-framework

		);

	}

	public function testInnerJoin() {

		$query = new SQLQuery();

		$query->setFrom('MyTable');

		$query->addInnerJoin('MyOtherTable', 'MyOtherTable.ID = 2');

		$query->addLeftJoin('MyLastTable', 'MyOtherTable.ID = MyLastTable.ID');

		$this->assertSQLEquals('SELECT * FROM MyTable '.

			'INNER JOIN "MyOtherTable" ON MyOtherTable.ID = 2 '.

			'LEFT JOIN "MyLastTable" ON MyOtherTable.ID = MyLastTable.ID',

			$query->sql($parameters)

		);

		$query = new SQLQuery();

		$query->setFrom('MyTable');

		$query->addInnerJoin('MyOtherTable', 'MyOtherTable.ID = 2', 'table1');

		$query->addLeftJoin('MyLastTable', 'MyOtherTable.ID = MyLastTable.ID', 'table2');

		$this->assertSQLEquals('SELECT * FROM MyTable '.

			'INNER JOIN "MyOtherTable" AS "table1" ON MyOtherTable.ID = 2 '.

			'LEFT JOIN "MyLastTable" AS "table2" ON MyOtherTable.ID = MyLastTable.ID',

			$query->sql($parameters)

		);

	}

	public function testJoinSubSelect() {

		);

	}

	public function testJoinSubSelect() {

		// Test sub-select works

		$query = new SQLQuery();

		$query->setFrom('"MyTable"');

		$query->addInnerJoin('(SELECT * FROM "MyOtherTable")',

			'"Mot"."MyTableID" = "MyTable"."ID"', 'Mot');

		$query->addLeftJoin('(SELECT "MyLastTable"."MyOtherTableID", COUNT(1) as "MyLastTableCount" '

			. 'FROM "MyLastTable" GROUP BY "MyOtherTableID")',

			'"Mlt"."MyOtherTableID" = "Mot"."ID"', 'Mlt');

		$query->setOrderBy('COALESCE("Mlt"."MyLastTableCount", 0) DESC');

		$this->assertSQLEquals('SELECT *, COALESCE("Mlt"."MyLastTableCount", 0) AS "_SortColumn0" FROM "MyTable" '.

			'INNER JOIN (SELECT * FROM "MyOtherTable") AS "Mot" ON "Mot"."MyTableID" = "MyTable"."ID" ' .

			'LEFT JOIN (SELECT "MyLastTable"."MyOtherTableID", COUNT(1) as "MyLastTableCount" FROM "MyLastTable" '

			. 'GROUP BY "MyOtherTableID") AS "Mlt" ON "Mlt"."MyOtherTableID" = "Mot"."ID" ' .

			'ORDER BY "_SortColumn0" DESC',

			$query->sql($parameters)

		);

		// Test that table names do not get mistakenly identified as sub-selects

		$query = new SQLQuery();

		$query->setFrom('"MyTable"');

		$query->addInnerJoin('NewsArticleSelected', '"News"."MyTableID" = "MyTable"."ID"', 'News');

		$this->assertSQLEquals(

			'SELECT * FROM "MyTable" INNER JOIN "NewsArticleSelected" AS "News" ON '.

			'"News"."MyTableID" = "MyTable"."ID"',

			$query->sql()

		);

	}

	public function testSetWhereAny() {

		$query = new SQLQuery();