Self-Joins - Revision history

Bacchas at 00:45, 24 October 2017

2017-10-24T00:45:27Z

← Older revision		Revision as of 00:45, 24 October 2017
Line 3:		Line 3:
	FROM customers c, customers r		FROM customers c, customers r
	WHERE c.referred = r.customer#;		WHERE c.referred = r.customer#;
	=== Self Joins using the JOIN Method ===		=== Self Joins using the JOIN Method ===
	SELECT r.firstname, r.lastname, c.referred, c.lastname "Referred"		SELECT r.firstname, r.lastname, c.referred, c.lastname "Referred"
	FROM customers c JOIN customers r		FROM customers c JOIN customers r
	ON c.referred = r.customer#;		ON c.referred = r.customer#;
	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 00:45, 24 October 2017

2017-10-24T00:45:15Z

← Older revision		Revision as of 00:45, 24 October 2017
Line 3:		Line 3:
	FROM customers c, customers r		FROM customers c, customers r
	WHERE c.referred = r.customer#;		WHERE c.referred = r.customer#;
			=== Self Joins using the JOIN Method ===
			SELECT r.firstname, r.lastname, c.referred, c.lastname "Referred"
			FROM customers c JOIN customers r
			ON c.referred = r.customer#;
	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 00:40, 24 October 2017

2017-10-24T00:40:57Z

← Older revision		Revision as of 00:40, 24 October 2017
Line 1:		Line 1:
	'''Self Joins are used when a table must be joined to itself to retrieve the data you need. Table aliases are required in the FROM clause to perform self-join'''		'''Self Joins are used when a table must be joined to itself to retrieve the data you need. Table aliases are required in the FROM clause to perform self-join'''
			SELECT r.firstname, r.lastname, r.referred, c.lastname "Referred"
			FROM customers c, customers r
			WHERE c.referred = r.customer#;

	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas: Created page with "'''Self Joins are used when a table must be joined to itself to retrieve the data you need. Table aliases are required in the FROM clause to perform self-join''' #Select C..."

2017-10-23T23:31:43Z

Created page with "'''Self Joins are used when a table must be joined to itself to retrieve the data you need. Table aliases are required in the FROM clause to perform self-join''' #Select C..."

New page

'''Self Joins are used when a table must be joined to itself to retrieve the data you need. Table aliases are required in the FROM clause to perform self-join'''

[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]