Cartesian Join or Cross Join - Revision history

Bacchas at 00:50, 25 October 2017

2017-10-25T00:50:22Z

← Older revision		Revision as of 00:50, 25 October 2017
Line 6:		Line 6:
	'''matched with each of the four records in the second table. Then the second record of the'''		'''matched with each of the four records in the second table. Then the second record of the'''
	'''first table is matched with each of the four records from the second table, and so on.'''		'''first table is matched with each of the four records from the second table, and so on.'''
			'''IF YOU CROSS JOIN A TABLE WITH 20 ROWS WITH A TABLE WITH 100 ROWS, THE QUERY WILL RETURN 2000 ROWS'''

	SELECT isbn, title, location, ' ' Count		SELECT isbn, title, location, ' ' Count

Bacchas at 18:27, 22 October 2017

2017-10-22T18:27:40Z

← Older revision		Revision as of 18:27, 22 October 2017
Line 7:		Line 7:
	'''first table is matched with each of the four records from the second table, and so on.'''		'''first table is matched with each of the four records from the second table, and so on.'''

			SELECT isbn, title, location, ' ' Count
			FROM books, warehouses
			ORDER BY location, title;

			SELECT isbn, title, location, ' ' Count
			FROM books CROSS JOIN warehouses
			ORDER BY location, title;

	[[#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 " '''In a Cartesian join, also called a Cartesian product or cross join, each record in the first''' '''table is matched with each record in the second table. This type of join..."

2017-10-22T17:58:15Z

Created page with " '''In a Cartesian join, also called a Cartesian product or cross join, each record in the first''' '''table is matched with each record in the second table. This type of join..."

New page

'''In a Cartesian join, also called a Cartesian product or cross join, each record in the first'''
'''table is matched with each record in the second table. This type of join is useful when you’re'''
'''performing certain statistical procedures for data analysis. Therefore, if you have three'''
'''records in the first table and four in the second table, the first record from the first table is'''
'''matched with each of the four records in the second table. Then the second record of the'''
'''first table is matched with each of the four records from the second table, and so on.'''

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